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 LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB FTW92LA143Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate terrain clearance. A factor was the loss of power as result of the uncoupling of the engine and the propeller.NTSB BFO92LA072Accident · 1 fatalLimited investigationFinal reportPiper J3C · Camillus, NYThe pilot's failure to properly judge the ground clearance required to perform an aerobatic manuever.NTSB SEA92FA114Accident · 1 fatalField investigationFinal reportCessna 172B · Eatonville, WAUndetermined.NTSB FTW92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Port Sulphur, LAThe pilot planned the approach with a tailwind and did not attain the proper touchdown point. Factors were the tailwind and the delayed aborted landing.NTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.NTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.NTSB LAX92FA204Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Cucamonga, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors in the accident were: the pilot's failure to obtain a weather briefing, the adverse weather conditions, his physical impairment due to drugs, and the mountainous…NTSB LAX92FA201Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Camarillo, CAThe pilot's failure to follow the published instrument missed approach procedure, and his failure to initiate a timely climb after being given a low altitude alert. Factors contributing to the accident were: the controller's failure to take positive action…NTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.NTSB ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.NTSB NYC92FA079Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Hamburg, PAThe pilot's improper in-flight decision, his failure to follow proper IFR procedures, and an improperly planned approach, which resulted in an inflight collision with rising terrain during the execution of the missed approach procedure. Factors related to the…NTSB SEA92FA077Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Briggsdale, COProper altitude was not maintained. Factors include ostentatious display.NTSB SEA92LA074Accident · 1 fatalLimited investigationFinal reportMoore Sonerai 1 · Harrisburg, ORThe pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…NTSB CHI92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 170B · St. James, MOThe pilot's failure to maintain clearance from terrain during the attempted takeoff and climb out. A related factor was the rising terrain.NTSB LAX92LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Cucamonga, CAThe pilot's failure to maintain an adequate altitude to avoid colliding into the rising terrain of the box canyon. A factor in the accident was the pilot having been distracted by an engine gage.NTSB LAX92FA164Accident · Serious injuriesField investigationFinal reportCessna 172N · Claremont, CAThe pilots improper preflight and inflight planning/decisions, his continued VFR flight into IMC conditions, and his failure to initiate timely remedial actions.NTSB FTW92FA099Accident · 1 fatalField investigationFinal reportRockwell 690A · Taos, NMThe pilot in command's failure to maintain the climb after departing the runway environment. Factors were the weather conditions and the dark night.NTSB LAX92FA156Accident · 3 fatalField investigationFinal reportBeech B95 · Devore, CAThe pilot's failure to maintain an adequate altitude while flying over mountainous terrain. Factors related to the accident were: the low clouds, dark night, and mountainous terrain.NTSB ANC92LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kenai, AKTerrain clearance was not maintained. Factors to the accident were: snow covered hilly terrain, and diverted attention.NTSB LAX92LA153Accident · 2 fatalLimited investigationFinal reportBeech F33A · Payson, AZThe pilot's poor preflight planning/preparation by intentionally flying into known adverse weather and his poor in-flight decision by not flying to an alternate airport when the airplane began to encounter icing. Contributing to this accident was the icing…NTSB ANC92LA051Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Port Alsworth, AKThe pilot inadvertently conducted VFR flight into IMC conditions. Contributing factors were low ceilings, snow, rain, icing conditions, and whiteout conditions.NTSB LAX92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 150M · San Andreas, CAThe flight instructor's poor inflight planning/decision by performing a 360 degree turn maneuver at a low altitude.NTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.NTSB FTW92LA089Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Wright, ARThe failure of the pilot to maintain altitude due to diverted attention.NTSB ATL92FA060Accident · 2 fatalField investigationFinal reportBritish Aerospace BAE-3101 · Alcoa, TNThe pilot's failure to use the airplane checklist which resulted in a gear up landing; and the pilot's failure to maintain flying speed which resulted in an uncontrolled collision with the ground.NTSB SEA92LA057Accident · 2 fatalLimited investigationFinal reportRobert L. Rice Davis DA-2A · Billings, MTThe failure of the pilot to maintain terrain clearance. Factors relating to the accident were the pilot's lack of experience and the rising terrain in the area.NTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.NTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.NTSB LAX92FA136Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Ft. Grant, AZ1) The pilot inadequately evaluating the enroute weather conditions, and, 2) the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see the mountainous terrain…NTSB DEN92LA036Accident · No injuriesLimited investigationFinal reportEnstrom TH-28 · Leadville, COThe pilot misjudging the descent rate and consequently delaying the flare. A factor was: downdraft.NTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.NTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…NTSB NYC92LA066Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gibson Island, MDThe pilot's failure to maintain proper altitude and clearance with water, which resulted in an in flight collision with water. Contributing to the accident was the pilot allowed the airplane to descend while making a right turn.NTSB LAX92FA120Accident · 7 fatalField investigationFinal reportPiper PA-31T-II · Big Bear, CAThe pilot's poor judgement in continuing visual flight into instrument meteorological conditions, in mountainous terrain obscured by clouds. Factors in the accident were: the pilot's failure to obtain a preflight weather briefing, the weather conditions, and…NTSB NYC92FA062Accident · 1 fatalField investigationFinal reportCessna 150 · White Lake, NYThe pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…NTSB LAX92LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Chandler, AZThe pilot not maintaining the proper descent rate and misjudging the landing flare which resulted in the aircraft pitching forward and rolling over.NTSB MIA92LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Fernandina Bch, FLSpatial disorientation and failure of the pilot-in-command to set the altimeter to the field elevation prior to departure. Contributing to the accident was the pilot's lack of total and recent experience.NTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…NTSB LAX92LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenfield, CAThe pilot's failure to maintain adequate altitude during an intentionally performed low altitude flight in mountainous terrain. Contributing factors related to the pilot's visual perception of the canyon area because of changes in the ambient lighting…NTSB SEA92FA041Accident · 2 fatalField investigationFinal reportPiper PA-23-180 · Gold Bar, WAThe pilot becoming inadvertently lost/disoriented. The environmental conditions were factors in the accident.NTSB FTW92LA062Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · E.I. Blk 108The pilot's failure to maintain altitude above the water. Factors were the pilot attempting flight into known adverse weather conditions of fog and low ceilings during dawn light conditions.NTSB CHI92LA081Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Minneapolis, MNA misjudged autorotation.NTSB MIA92LA068Accident · 3 fatalLimited investigationFinal reportPiper PA-32-301 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane crashed in the Atlantic Ocean and was not located.NTSB DEN92FA024Accident · 3 fatalField investigationFinal reportCessna 421B · Steamboat Spgs, COAirframe ice and the pilot's failure to remove it. Factors were: aircraft weight exceeded and lack of pilot certification.NTSB DCA92MA016Accident · 2 fatalMajor investigationFinal reportBeech 1900C · Gabriels, NYFailure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…NTSB ANC92LA060Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Port Walter, AKThe design stress limits of the airplane were exceeded. A factor to the accident was: rough water.