NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB BFO93LA098Accident · 1 fatalLimited investigationFinal reportCessna 150 · Milroy, PAThe pilot's inadvertent flight into instrument meteorological conditions, and his failure to maintain clearance with terrain. Factors related to the accident include mountain obscuration and fog.NTSB SEA93FA125Accident · 3 fatalField investigationFinal reportCessna 172P · Enumclaw, WAInadvertent VFR flight into IMC. Factors to the accident were: fog and rain.NTSB LAX93FA231Accident · 4 fatalField investigationFinal reportBeech D-50E · Lee Vining, CAThe pilot's inadequate weather evaluation; inadequate in-flight planning and decision making; and the pilot's continued VFR flight into instrument meteorological conditions.NTSB LAX93LA227Accident · No injuriesLimited investigationFinal reportHughes 269C · Van Nuys, CAthe student pilot's failure to maintain the altitude while maneuvering toward the parking area. The student pilot's lack of total experience was a factor in this accident.NTSB FTW93FA165Accident · 4 fatalField investigationFinal reportFairchild SA-226T · Santa Fe, NMThe pilot's poorly planned circling approach, and his failure to maintain an adequate altitude. Factors which contributed to the accident were: the dark night and a lack of visual reference.NTSB LAX93LA225Accident · 1 fatalLimited investigationFinal reportCessna 172N · Page, AZthe pilot's selection of an inadequate cruise altitude. A factor in the accident was the high winds and turbulence in the vicinity of the cliffs.NTSB FTW93LA156Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARPilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.NTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.NTSB CHI93DER01Accident · 1 fatalFinal reportPitts S1 · Madison, MNThe pilot's failure to maintain adequate terrain clearance during aerobatic maneuvers.NTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.NTSB FTW93LA151Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ville Platte, LAThe pilot's failure to maintain ground clearanceNTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.NTSB CHI93LA169Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Garden City, KSThe pilot-in-command's not maintaining proper altitude.NTSB LAX93LA208Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Corona, CAThe failure of the pilot to accomplish the published emergency procedure by not immediately lowering the collective to regain main rotor RPM. A factor in the accident was the pilot's selection of a cruise altitude insufficient to allow for contingency…NTSB LAX93LA199Accident · 1 fatalLimited investigationFinal reportCanadair F-86E MK.6 · Santa Ana, CAThe pilot's inadequate planning/decision concerning performance of an aerobatic maneuver, and his failure to maintain adequate altitude/clearance above the runway during recovery from the maneuver. A factor related to the accident was: the pilot's lower…NTSB DEN93FA053Accident · 2 fatalField investigationFinal reportBeech 65-A90 · Mount Ida, ARThe pilot's failure to establish an adequate climb rate. Factors in the accident were: pilot fatigue from lack of sleep, and the weather conditions.NTSB DEN93FA052Accident · 2 fatalField investigationFinal reportBeech 58 · Telluride, COFailure of the pilot-in-command to plan and/or assure selection of an altitude/course combination that would provide terrain clearance, and failure of the other (second) pilot to adequately monitor the situation. Darkness, high (mountainous) terrain, and…NTSB CHI93LA146Accident · No injuriesLimited investigationFinal reportChampion 7GCBA · Duluth, MNPilot in command failed to maintain directional control.NTSB ANC93FA054Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kashwitna, AKThe pilot in command not maintaining control of the airplane and his inadequate preflight preparation for high mountain terrain big game operations. Factors contributing to the accident were: the high terrain condition and the lack of total experience in the…NTSB LAX93FA177Accident · Serious injuriesField investigationFinal reportBritish Aerospace BA 3101 · Merced, CAThe first officer's failure to maintain an adequate rate of climb after a single-engine loss of power was simulated, and the company check pilot's inadequate supervision and failure to note the descent. Darkness was a related factor.NTSB ATL93LA081Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Payne, ALThe pilot's failure to compensate for winds during the initial takeoff that resulted in the airplane colliding with the runway, exceeding the design limits of the aircraft and upon landing at the destination airport, the collapse of the main landing gear.NTSB SEA93FA088Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-35 · Casper, WYFailure of the pilot to maintain proper altitude during the night IFR approach in instrument meteorological conditions (IMC).NTSB CHI93LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Northwood, NDThe flight instructor's inadequate supervision of the flight.NTSB ANC93FA050Accident · 2 fatalField investigationFinal reportCessna 207 · Nome, AKThe pilot initiated VFR flight into instrument meteorological and whiteout conditions. Factors which contributed to the accident were: inadequate supervision of the pilot by the company, inadequate oversight by the federal aviation administration, the pilot's…NTSB SEA93FA084Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Estacada, ORFailure of the pilot to maintain proper clearance (and/or altitude) from moutainous terrain. Factors related to the accident were: darkness, clouds, low ceilings, and the high (mountainous) terrain in the area of the accident site.NTSB CHI93LA121Accident · No injuriesLimited investigationFinal reportManville Avid Flyer · Lincoln, MOThe pilot's failure to maintain control of the airplane, and his operation of an airplane with known defects.NTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.NTSB ANC93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Mekoryuk, AKPilot-in-command initiated VFR flight into IMC conditions. A factor in this accident was the whiteout weather conditions.NTSB MIA93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Walls, MSThe pilot-in-command's delay in aborting the landing.NTSB MIA93LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLImproper in-flight planning/decision by the student pilot, and inadequate supervision of the flight by the instructor pilot (CFI). Factors related to the accident were: the tailwind, and the student pilot's improper flare and transition to an aborted landing,…NTSB ANC93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Drift River, AKThe pilots inadvertent VFR flight into IMC conditions. Factors were the rising terrain and the whiteout conditions.NTSB ANC93FA045Accident · 1 fatalField investigationFinal reportPiper PA-14 · Rainey Pass, AKThe pilot-in-command's attempt to fly VFR in IMC conditions. Factors were the mountainous terrain and whiteout conditions.NTSB CHI93LA114Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Park, KSThe pilot-in-command's physical incapacitation for reason or reasons undetermined.NTSB FTW93FA103Accident · 4 fatalField investigationFinal reportBeech 58 · Grants, NMThe pilot's inadequate preflight planning/preparation and the selection of an altitude that would not provide terrain clearance along his planned route. Factors were the dark night conditions and the mountainous terrain.NTSB ANC93LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Port Alsworth, AKThe non instrument rated pilot in command entering instrument meteorological conditions. A factor in the accident was the snow/whiteout condition.NTSB ANC93LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Iliamna, AKThe pilot in commands attempt to conduct a visual flight during instrument meteorological conditions and his failure to maintain control of the aircraft during the emergency 180 degree turn maneuver to reverse direction. Factors in the accident were the snow…NTSB FTW93FA096Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXThe pilot's failure to maintain control of the airplane for undetermined reasonsNTSB SEA93FA071Accident · 2 fatalField investigationFinal reportCessna 402B · Oakley, UTPoor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.NTSB CHI93LA094Accident · No injuriesLimited investigationFinal reportBeech B90 · Albert Lea, MNAn inadvertent stall due to ice in the pitot/static system.NTSB LAX93LA131Accident · Minor injuriesLimited investigationFinal reportSchicora Osprey 2 · Joshua Tree, CAThe failure of the pilot flying to attain adequate airspeed for lift off and the resulting inadvertent stall mush condition during the initial climb.NTSB LAX93LA129Accident · No injuriesLimited investigationFinal reportCessna 182R · Warner Springs, CAThe pilots decision to attempt flight into known adverse weather conditions.NTSB LAX93FA125Accident · 2 fatalField investigationFinal reportCessna T210M · Coalinga, CAThe pilots inadequate preflight planning and his failure to select a cruise altitude which would ensure adequate terrain clearance during the night cross country. Factors in the accident were: the mountainous nature of the terrain and the dark night light…NTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.NTSB FTW93LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Vermillion 39The pilot's failure to maintain proper altitude.NTSB LAX93FA110Accident · 4 fatalField investigationFinal reportCessna 172K · Gorman, CAThe pilot's continued flight into known adverse weather conditions and continued visual flight into instrument meteorological conditionsNTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.NTSB FTW93LA078Accident · No injuriesLimited investigationFinal reportRans S-7 · Lancaster, TXAircraft control not maintained by pilot. Turbulence due to strong, gusty winds was a factorNTSB FTW93LA077Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Marfa, TXThe pilot's continued descent below the proper altitude. Factors were the dark night, fog, and the crew's poor coordination.NTSB MIA93LA056Accident · 1 fatalLimited investigationFinal reportFerran DOMINATOR-BIG ONE · Apopka, FLUndetermined.NTSB LAX93LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilots inadequate compensation for the existing wind conditions and his delay in executing a go around. A factor in the accident was the pilot's lack of total experience.