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 CHI99LA215Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Page, NDthe pilot's failure to compensate for the wind conditions. Factors were the sudden windshift and the crops.NTSB LAX99LA223Accident · Serious injuriesLimited investigationFinal reportDevor MXL II · Tonopah, AZThe failure of the uncertificated pilot to maintain control of the aircraft.NTSB NYC99LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Tinicum, PAThe pilot's failure to maintain a proper altitude above the water.NTSB CHI99LA187Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5KB · Iowa City, IAthe pilot stalled the airplane. Factors included the instructor pilot's inadequate preflight briefing and improper in flight decision.NTSB MIA99LA178Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Charlotte, NCThe pilot misjudged the flare during the landing.NTSB DEN99LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Junction, COThe pilot's inadequate preflight planning and preparation for the runway and the environment in which he intended to fly. Factors were high-density altitude and a dirt runway.NTSB LAX99LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Weaverville, CAthe pilot's failure to follow prescribed procedures and directives for the particular airport.NTSB ANC99LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to maintain clearance from terrain. Factors associated with the accident are the confined/congested landing/takeoff area, and rocks/boulders in the takeoff area.NTSB SEA99LA081Accident · 1 fatalLimited investigationFinal reportD. Wayne Smith Wayncraft 14 · Libby, MTCollision with terrain for undetermined reasons.NTSB SEA99LA079Accident · No injuriesLimited investigationFinal reportSnow S2C · Paul, IDThe pilot's inaccurate weight and balance calculations, and his delay in jettisoning the load which resulted in his failure to clear rising terrain. Contributing to the accident was the high density altitude, and the pilot's intentional operation with known…NTSB DEN99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Parkman, WYThe pilot's inadequate in-flight planning by exceeding the helicopter's performance climb capability. Factors were the downdraft encountered during initial climb following takeoff, and the high density altitude.NTSB NYC99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructors failure to maintain climb airspeed during the go-around, which degraded climb performance, resulting in an in-flight collision with terrain. Factors in the accident were, delay in executing a go-around, retracting the flaps to 10…NTSB NYC99LA124Accident · 2 fatalLimited investigationFinal reportToman Great Lakes 2T-1AJ · Painesville, OHThe pilot's improper decision to conduct low-level aerobatic flight, and his lack of adequate altitude for the maneuver attempted.NTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).NTSB LAX99LA190Accident · 1 fatalLimited investigationFinal reportBeech B90 · Mokuleia, HIThe pilot's incapacitation due to the effects of hypoxia from repeated flights to altitudes above 18,000 feet msl without supplemental oxygen.NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB IAD99LA042Accident · No injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDwas the pilot's improper remedial action when he improperly used the elevator during the landing flare.NTSB MIA99LA155Accident · 1 fatalLimited investigationFinal reportAero Commander 500B · Atlantic Ocean (Atlantic Ocean)an in-flight collision with water for undetermined reasons, due to the wreckage never being recovered from the water.NTSB NYC99FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA28RT-201T · Plymouth, MAundetermined (missing airplane)NTSB NYC99FA100Accident · 1 fatalField investigationFinal reportStock S-1S · Westtown, NYThe pilot's inability to recover from an intentional stall spin maneuver. A factor in the accident was the change in the airplane's center of gravity which made the airplane more difficult to recover from a spin.NTSB FTW99LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Marfa, TXThe pilot's failure to maintain clearance with the dirt bank during the landing flare.NTSB LAX99LA166Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Concord, CAThe inadequate supervision of the student pilot by the flight instructor during the practice autorotation, which resulted in a delayed flare and the tail rotor contacting the ground. A factor was a misinterpreted communication between the flight instructor…NTSB LAX99FA162Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Trona, CAThe pilot's failure to maintain an adequate terrain clearance altitude while performing intentional low altitude passes over a campground.NTSB LAX99FA160Accident · 1 fatalField investigationFinal reportCessna 150G · Gorman, CAThe pilot's intentional flight into adverse weather conditions beneath a low ceiling in mountainous terrain.NTSB ATL99LA073Accident · No injuriesLimited investigationFinal reportCessna 140A · Dallas, GAThe pilot's selection of unsuitable terrain/landing area for a short field landing, and his delay in executing a go-around.NTSB LAX99LA154Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Lake Mary, AZThe pilot's intentional buzzing and misjudged altitude/clearance with the nearby rising terrain. Contributing factors were the high density, the airplane's high gross weight, and the pilot's improper in-flight decisions.NTSB LAX99LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Nuys, CAThe check pilot's inadequate supervision of the flight and his failure to ensure that an adequate altitude margin existed during the maneuver.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.NTSB CHI99FA227Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · St. Clair Shore, MIUndetermined as the aircraft was not recovered.NTSB ANC99LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Chefornak, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was rough and uneven terrain.NTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.NTSB FTW99LA095Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARThe pilot's failure to maintain terrain clearance during the downwind departure. Factors were the tailwind and the wet soft grass airstrip.NTSB IAD99GA036Accident · 13 fatalFinal reportMil MI-8MTV-1 · Hinche, HaitiThe flightcrew's inability to maintain visual contact with mountainous terrain in night, instrument meteorological conditions. Contributing to the accident was a lack of preparation and support for difficult flight conditions, including lack of coordination…NTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.NTSB DEN99FA051Accident · 2 fatalField investigationFinal reportCessna 172 · Gill, COThe pilot's intentional maneuvering at an unwarranted low altitude resulting in a collision with the ground. Factors were the pilot's ostentatious behavioral display and reduced lighting (dusk) conditions.NTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.NTSB LAX99TA105Accident · No injuriesFinal reportChristen Industries A-1 · Battle Mountain, NVFailure of the pilot to maintain clearance from terrain. A factor was the dust devil encountered by the airplane.NTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB LAX99FA096Accident · 1 fatalField investigationFinal reportBeech C99 · Bishop, CAthe pilot's failure to follow procedures and directives and his failure to maintain clearance from mountainous terrain.NTSB ANC99FA028Accident · Serious injuriesField investigationFinal reportBeech 1900C · Saint Mary'S, AKThe pilot's descent below the minimum descent altitude on the instrument approach. Factors were pilot fatigue resulting from the pilot's rest period being interrupted by scheduling discussions and the night weather conditions of low ceilings and whiteout.NTSB MIA99FA075Accident · 1 fatalField investigationFinal reportCessna 210J · Naples, FLIn-flight collision with water while on base turn to final at night for undetermined reasons.NTSB LAX99FA091Accident · 1 fatalField investigationFinal reportCessna 150J · Mariposa, CAThe pilot's premature descent into terrain during a dark nighttime approach. Also causal was his physiological impairment due to alcohol. A contributing factor was his psychological condition.NTSB FTW99FA075Accident · 5 fatalField investigationFinal reportCessna 182B · Ozona, TXthe pilot's failure to obtain/maintain clearance from terrain during initial climb after take off. A contributing factor was the dark night.NTSB LAX99FA090Accident · 1 fatalField investigationFinal reportNorth American T-28C · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.NTSB MIA99LA070Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Pompano Beach, FLThe CFI's decision not to follow procedures and directives (initiate a go-around/power recovery) during a simulated 180 autorotation resulting in a hard landing and in flight collision with terrain.NTSB CHI99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Rockford, ILthe failure of the pilot to maintain flying speed and ground clearance while on a night circling approach. Factors were existing icing conditions and the airframe and windshield icing.NTSB LAX99FA080Accident · 2 fatalField investigationFinal reportNorth American T-6G-NA · New River, AZThe pilot's delayed recovery after an intentional stall/spin of 3 to 4 rotations. A factor was the pilot's inadequate entry altitude for the intended maneuver.NTSB LAX99FA078Accident · 1 fatalField investigationFinal reportCessna 182P · Danville, CAThe pilot's disregard for the preflight weather briefing, and his intentional continuation into adverse weather conditions.NTSB DEN99LA032Accident · No injuriesLimited investigationFinal reportCessna 182M · Longmont, COThe pilot's poor judgment by intentionally buzzing. A factor was an unfavorable wind that caused inadequate altitude/clearance to maneuver and avoid nearby houses.