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 SEA93FA194Accident · 1 fatalField investigationFinal reportCessna 182D · Lucile, IDThe pilot's failure to maintain airspeed resulting in an aerodynamic stall. The mountainous terrain was a factor.NTSB FTW93FA255Accident · 7 fatalField investigationFinal reportGates Learjet 25D · Pecos, NMWas physical impairment of the pilot in command from alcohol and drugs. A factor was the first officer's lack of experience in the lear jet.NTSB BFO93LA158Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Block Island, RIImproper in-flight planning/decision by the pilot, and his failure to attain proper runway alignment.NTSB ANC93LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Kijik River, AKThe pilot's failure to maintain a proper altitude during the low pass.NTSB FTW93LA249Accident · No injuriesLimited investigationFinal reportCessna T188C · Rockport, TXInadvertent stall/mush experienced by the pilot.NTSB ANC93LA170Accident · 1 fatalLimited investigationFinal reportCessna 185 · Hulahula River, AKThe pilot in command's attempted VFR flight into IMC conditions. Factors contributing to the accident were the high terrain and the obscuration.NTSB CHI93LA341Accident · No injuriesLimited investigationFinal reportCessna R182 · St Louis, MOthe pilot's delay in lowering the landing gear prior to touchdown.NTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.NTSB DEN93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMImproper planning and decision making by the pilot in command in descending into a valley at an altitude providing no escape route in mountainous terrain.NTSB ANC93LA158Accident · No injuriesLimited investigationFinal reportHughes 369D · Mount Iliamna, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factors were the mountainous terrain and gusty winds.NTSB ANC93LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Atigan Pass, AKThe pilot's improper inflight planning/decision and delay in taking remedial action.NTSB MIA93FA184Accident · 1 fatalField investigationFinal reportReher, Kent O. RV 6 · Grand Ridge, FLUndetermined.NTSB ANC93LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Beaver Creek, AKThe improper altitude flown by the pilot in command.NTSB LAX93LA336Accident · No injuriesLimited investigationFinal reportContinental Copters Mark 5 · San Juan Bautis, CAthe pilot's failure to maintain sufficient altitude to clear the crops. The pilot's diverted attention during the aerial application flight is a factor in this accident.NTSB CHI93LA347Accident · 1 fatalLimited investigationFinal reportWells Pitts S-2-S · Bloomington, ILthe pilot in command continued the aerobatic maneuver too long to effect a safe level off.NTSB ANC93LA156Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Galbraith Lake, AKThe pilots improper preflight planning/preparation. A factor was the unfavorable wind.NTSB MIA93LA177Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Punta Gorda, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective pitch) during a simulated autorotation with turn, resulting in an in flight collision with terrain with the tail skid and tailrotor blades.NTSB NYC93FA159Accident · 2 fatalField investigationFinal reportSwearingen SA-226-TC · Hartford, CTFailure of the copilot (second-in-command) to follow the checklist, assure the gear was extended for landing and attain or maintain adequate airspeed (VMC); and failure of the pilot-in-command (PIC) to properly supervise the flight and take sufficient…NTSB ANC93LA144Accident · Minor injuriesLimited investigationFinal reportGrumman G-21 · Togiak River, AKThe pilot in command's improper preflight decision making and selection of unsuitable terrain for takeoff.NTSB NYC93LA150Accident · No injuriesLimited investigationFinal reportErco 415D · Thomaston, METhe improper weather evaluation by the non-instrument-rated pilot, and the subsequent VFR flight into instrument meteorologial conditions, resulting in a collision with the terrain.NTSB LAX93LA317Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Julian, CAThe pilot's poor inflight decision in selecting an altitude insufficient to ensure adequate terrain clearance.NTSB FTW93FA235Accident · 1 fatalField investigationFinal reportMooney M20C · Big Lake, TXThe pilot's failure to maintain terrain clearance.NTSB ANC93LA140Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Near Skwentna, AKThe pilot in command's inadequate preflight planning and preparation. A factor in the accident was the pilot's lack of familiarity with the particular aircraft's performance.NTSB ANC93FA134Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Atigun Pass, AKThe pilot-in-command's intentional VFR flight into instrument meteorological conditions and his unfamiliarity with the geographical area. Factors were the rain and fog.NTSB LAX93LA309Accident · 1 fatalLimited investigationFinal reportCessna 182P · Dayton, NVThe pilot's failure to maintain an altitude sufficient to clear terrain due to alcohol and drug impairment.NTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.NTSB SEA93LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monroe, WAThe improper inflight decision by the PIC and his failure to attain proper runway alignment. Factors relating to the accident were the dark night light conditions, unavailability of runway lights, and lack of recent night flight time by the PIC.NTSB LAX93LA302Accident · No injuriesLimited investigationFinal reportRobinson R22-B · Venice, CAThe failure of the pilot to maintain proper main rotor RPM, altitude, and airspeed during the performance of a steep turn. Inadequate in-flight planning and overconfidence in the pilot's abilities were factors in this accident.NTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.NTSB CHI93LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crookston, MNThe pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.NTSB MIA93LA165Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Columbus, MSThe pilot-in-command's improper decision to turn the fuel selector off prematurely during his attempted landing.NTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.NTSB ANC93LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Kelly River Bar, AKThe pilot's failure to assure that adequate takeoff distance was available. The rough/uneven terrain was a factor.NTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.NTSB FTW93LA214Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bono, ARThe airplane's takeoff performance being exceeded by the PIC. A factor was the pilot's inability to safely reject the takeoff.NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.NTSB SEA93LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Snohomish, WAThe pilot misjudged the landing flare.NTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.NTSB MIA93LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G · Panama City, FLImproper planning/decision by the pilot-in-command and his failure to maintain rotor RPM, which resulted in failure of the helicopter to attain effective translational lift. Factors related to the accident were: the fence & terrain conditions.NTSB LAX93FA260Accident · 1 fatalField investigationFinal reportHughes 269A · Henderson, NVthe pilot's improper use of the collective control and his failure to maintain adequate RPM during an autorotative descent during a practice power off landing. A factor which contributed to the accident related to the pilot's lack of recent experience…NTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.NTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotNTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterNTSB LAX93LA248Accident · 1 fatalLimited investigationFinal reportHenderson Rutan Long EZ · San Pedro Bay, CAthe pilots failure to maintain an adequate terrain clearance altitude while maneuvering over the water at low altitude.NTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.NTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.NTSB ANC93FA081Accident · Minor injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe pilot in command exceeding the maximum authorized gross takeoff weight of the airplane and his failure to compensate for the wind conditions. A factor in the accident was the gusty wind condition.NTSB LAX93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Montgomery Pass, NVThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the downdraft, low ceiling, rain, obscuration, and the mountainous terrainNTSB LAX93LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Davenport, CAThe pilot's failure to maintain directional control to avoid the high vegetation. Factors relating to this accident were the failure of the pilot to obtain the climb airspeed and the inadvertent stall/mush.NTSB BFO93LA099Accident · No injuriesLimited investigationFinal reportCessna 177 · Newport, NHThe pilot's failure to properly recover from a bounced landing, and his failure to maintain directional control during the aborted landing.