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 ANC95LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of the weather conditions, and improper inflight planning/decision to assure clearance from mountainous terrain. A factor relating to the accident was: the unfavorable/gusty wind condition.NTSB ANC95LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's failure to maintain clearance from tall vegetation during a low pass.NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.NTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.NTSB ANC95FA086Accident · 4 fatalField investigationFinal reportPiper PA-31 · Valdez, AKThe pilot's failure to follow the published IFR (missed approach) procedure and assure adequate altitude/clearance from mountainous terrain.NTSB SEA95FA137Accident · 2 fatalField investigationFinal reportBeech A36 · Brinnon, WAThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain clearance from the terrain. Factors in the accident were the mountains and the clouds.NTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.NTSB LAX95FA217Accident · 1 fatalField investigationFinal reportCessna 172N · Vidal Junction, CAThe pilot's failure to maintain an altitude adequate to avoid the mountainous/hilly terrain. Contributing to the accident was the glare from the setting sun.NTSB SEA95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Laurel, MTThe selection of unsuitable terrain for landing. A factor to the accident was tall vegetation.NTSB LAX95LA215Accident · Serious injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Dayton, NVthe pilot's delayed decision to extend and use the engine to maintain adequate terrain clearance after encountering downdrafts.NTSB SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…NTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.NTSB CHI95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Williston, NDThe failure of the pilot to maintain directional control on takeoff. The soft condition of the field was a factor.NTSB CHI95LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INThe pilot's improper execution of the ILS approach. Factors related to the accident were the fog and the pilot's lack of total flight time in actual instrument conditions.NTSB SEA95LA109Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Rawlins, WYThe pilot's failure to maintain a proper climb rate. Factors contributing to the accident were the high density altitude and the rising terrain.NTSB FTW95LA224Accident · 2 fatalLimited investigationFinal reportCornelius LONG-EZ · Clines Corner, NMThe pilot flying the aircraft into IMC conditions at an altitude which was inadequate to clear surrounding terrain. Factors were low ceiling and fog.NTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.NTSB FTW95LA214Accident · Serious injuriesLimited investigationFinal reportCessna 172H · San Ignacio, NMThe pilot flying at an inadequate altitude to clear surrounding terrain. Factors were: high mountainous terrain and high density altitude.NTSB LAX95LA190Accident · 3 fatalLimited investigationFinal reportStol UC-1 · Saipan, Sarkan inflight collision with the ocean for undetermined reasons.NTSB CHI95LA157Accident · No injuriesLimited investigationFinal reportCessna 182P · French Lick, INthe pilot's not attaining a recovery from a bounced landing. Factors were high obstructions, and the pilot's intentional precautionary landing on rough/uneven and soft terrain.NTSB LAX95LA184Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Honolulu, HIthe pilot's attempted flight in close proximity to terrain under gusty wind conditions at an inadequate terrain clearance altitude.NTSB NYC95FA105Accident · 2 fatalField investigationFinal reportBeech BE60 · Olney, ILThe pilot's improper IFR procedures by descending below the minimum descent altitude and not executing the published missed approach procedures. A factor in thE accident was the low overcast and fog conditions.NTSB NYC95FA103Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Toano, VAThe pilot misjudged altitude and distance which resulted in an undershoot of the landing area and collision with water. Contributing factors are inadequate helipad lighting and a dark night light condition.NTSB ANC95LA050Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dillingham, AKThe pilot's inadequate preflight planning and preparation. Factors associated with the accident are: the dispatcher's decision to dispatch a multi-engined airplane to a short, soft airstrip, and inadequate company management oversight/surveillance.NTSB LAX95LA181Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Colusa, CAthe pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…NTSB SEA95LA092Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bliss, IDThe pilot's continued VFR flight into instrument meteorological conditions. Factors include low ceiling, rain and fog.NTSB ATL95LA093Accident · Minor injuriesLimited investigationFinal reportLet L-23 Super Blanik · Spartanburg, SCThe pilot's inadvertent use speed brakes during takeoff.NTSB LAX95LA179Accident · 1 fatalLimited investigationFinal reportCessna 152 · Palos Verdes, CAthat the pilot initiated the flight into known adverse weather, and inadvertent flight into instrument meteorological conditions.NTSB ANC95LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Old Harbor, AKThe pilot's continued flight into known adverse weather. The whiteout condition was a factor.NTSB CHI95LA135Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Napoleon, MIthe pilot's failure to retract the wing flaps prior to takeoff and the subsequent failure of the airplane to climb during takeoff.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB NYC95LA091Accident · No injuriesLimited investigationFinal reportMooney M20K · Marshfield, MAthe pilot misjudged the flare, resulting in a bounced landing and impact with the terrain. A factor in this accident was an improper recovery from a bounced landing.NTSB LAX95FA173Accident · 4 fatalField investigationFinal reportCessna 182P · Jerome, AZthe pilot's improper in-flight decision to continue the daytime flight into known adverse weather conditions at an inadequate altitude to clear mountainous terrain.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB ANC95FA044Accident · 2 fatalField investigationFinal reportCessna 180B · Cantwell, AKThe pilot's continued VFR flight into IMC conditions. Weather conditions consisting of low ceilings and turbulence were factors in the accident.NTSB FTW95LA168Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Tulsa, OKThe pilot's improper emergency procedure preventing emergency gear extension. A factor was the loss of electrical alternator power for undetermined reasons.NTSB CHI95LA122Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSthe pilot taking off the airplane at a low liftoff speed (Vlo). A factor associated with the accident was a stall/mush encountered by the pilot.NTSB CHI95LA120Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · St. Clair, MOthe pilot's impairment of judgment and performance due to drugs which led to his operating the airplane with a known mechanical deficiency.NTSB ATL95LA077Accident · Minor injuriesLimited investigationFinal reportBeech B-19 · Jackson, ALThe pilot's continued operation of the airplane with a known deficiency in available power.NTSB LAX95LA153Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Healdsburg, CAthe instructor failed to adequately monitor the student pilot's actions and to react within the control margin necessary to successfully initiate a corrective action.NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.NTSB CHI95LA343Accident · 1 fatalLimited investigationFinal reportBeech C23 · Waukegan, ILThe pilot's VFR flight into instrument meteorolical conditions.NTSB BFO95LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Oakland, MDthe student pilot's abrupt remedial action during the aborted landing attempt. Related factors are the student pilot's lack of total experience, inadequate airspeed and the low altitude.NTSB SEA95LA071Accident · No injuriesLimited investigationFinal reportCessna 172D · Lake Oswego, ORThe pilot's improper touchdown on the surface of the water.NTSB LAX95FA144Accident · 1 fatalField investigationFinal reportCessna 310Q · Kahului, Maui, HIthe pilot's failure to maintain an adequate terrain clearance altitude while flying in a mountainous area at night.NTSB ATL95LA073Accident · No injuriesLimited investigationFinal reportCessna 150M · Fuquay-Varina, NCThe certified flight instructor's failure to complete the takeoff checklist which resulted in an attempted takeoff with the wing flaps extended.NTSB LAX95FA141Accident · 1 fatalField investigationFinal reportCessna 208B · Reno, NVthe pilot's failure to comply with published instrument approach procedures by a premature descent below the minimum altitude specified for the approach.NTSB ANC95LA036Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's continued VFR flight into IMC conditions and a failure to maintain altitude. A factor in the accident was 'whiteout' weather conditions.NTSB NYC95LA073Accident · No injuriesLimited investigationFinal reportBeech 23 · Plymouth, NHThe pilot's failure to maintain runway alignment during the aborted takeoff. Factors related to the accident were: the adverse runway conditions and snowbank beside the runway.NTSB FTW95FA134Accident · 1 fatalField investigationFinal reportHinshaw, Keith T. BD5TP · Byers, COFailure by the pilot in command to maintain control of the aircraft. Factors were: lack of experience in type of aircraft and lack of experience in type of operation.