NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 ANC93FA013Accident · 3 fatalField investigationFinal reportCessna 402C · Kiana, AKThe pilot in command's attempt to fly VFR into IMC conditions. Factors were snow, whiteout conditions, and mountainous terrain.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB LAX93LA032Accident · 1 fatalLimited investigationFinal reportR.W. Sherman Turbulent · Adelanto, CAThe pilot's improper emergency decision to attempt to return to the departure area. Contributing to this accident was the undetermined loss of power, inadequate altitude, and failure to maintain the airspeed.NTSB LAX93LA031Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIThe flight's encounter with unforecasted unfavorable winds (loss of thermal lift) and downdrafts while on final approach to the runway.NTSB FTW93LA034Accident · No injuriesLimited investigationFinal reportTodd Goudeau KR-2 · San Marcos, TXPower loss due to carburetor icing. Factors were the unsuitable landing area and no carburetor deice system installed on the powerplant.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB ATL93FA021Accident · No injuriesField investigationFinal reportHawker Siddeley DH.125-400A · Nashville, TNThe company mechanic's improper preflight of the aircraft, resulting in a foreign object (flashlight) being left in the nose gear well.NTSB MIA93FA015Accident · No injuriesField investigationFinal reportDouglas DC-7CF · Fort Lauderdale, FLFailure of the #4 engine for an undetermined reasons(s), and the inability of the airplane to remain airborne due to the overgross weight takeoff performed by the pilot. Factors which contributed to the accident were: the questionable airworthiness of the…NTSB LAX93FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman AA-1B · Pacific Ocean (Pacific Ocean)Undetermined. The aircraft was not located.NTSB CHI93FA028Accident · Minor injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Wahpeton, NDOther maintenance personnel's improper maintenance (installation).NTSB ANC93FA012Accident · 2 fatalField investigationFinal reportCessna 207 · Montague Island, AKThe pilot's intentional VFR departure into instrument meteorological conditions, and the company chief pilot's failure to exercise adequate supervision. The weather conditions were factors in the accident.NTSB SEA93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Evanston, WYThe pilot's disregard of hazardous weather advisory, resulting in flt into forecast icing conditions in an acft not equipped or certified for the flt, and the improper inflt planning by pilot during the VFR approach that resulted in impact with terrain short…NTSB LAX93LA030Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Pahrump, NVThe pilot misjudged the pull up altitude.NTSB LAX93IA029Incident · No injuriesIncident investigationFinal reportPiper PA-31T-620 · Medford, ORFatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.NTSB FTW93FA032Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Uvalde, TXClearance not maintained by pilot in command.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB MIA93LA014Accident · Minor injuriesLimited investigationFinal reportBell 47-G3-B1 · Palm Beach, FLThe pilot's inadequate preflight planning. A factor was the pilot's failure to maintain rotor RPM during the autorotation.NTSB MIA93IA013Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Titusville, FLThe failure of contract maintenance personnel to comply with written maintenance instructions, resulting in the failure of the nose gear on landing roll.NTSB FTW93LA031Accident · No injuriesLimited investigationFinal reportCessna U206D · Fort Stockton, TXThe pilot's failure to follow published fuel system sumping procedures before flight and total loss of power due to water contaminated fuel. Factors were the drizzle and icing conditions and the lack of suitable terrain.NTSB LAX93LA027Accident · No injuriesLimited investigationFinal reportBeech 36TC · Sedona, AZThe pilot's poorly planned approach and delay in executing the appropriate remedial action. Contributing to this accident was the pilot's failure to maintain the proper glidepath and encountering a downdraft.NTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.NTSB SEA93T#A01Accident · No injuriesClass 3Final reportBeech 58 · Bates, ORNTSB SEA93LA017Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Green River, UTThe inadequate preflt planning/preparation by the pilot resulting in inflt encounter with weather and his failure to maintain proper rate of descent during an emergency forced landing. A factor relating to the accident was the turbulent weather conditions.NTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.NTSB FTW93LA029Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mcgregor, TXInadvertent stall by the pilot in command. Factors were the pilot's selection of the wrong runway, and the wind conditions.NTSB FTW93LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Vernon, TXThe student pilot's failure to maintain directional control of the airplane. A factor was the stall/mush.NTSB CHI93FA024Accident · 2 fatalField investigationFinal reportCessna U206F · Valentine, NEThe pilot-in-command's intentional flight into an area of low ceilings, and his failure to maintain an altitude sufficient for terrain clearance. Factors which contributed to the accident were: the pilot's overconfidence, the low ceiling and the dark night…NTSB BFO93FA001Accident · 1 fatalField investigationFinal reportPiper J5A · Lumberton, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and an uncontrolled descent at an altitude not possible for recovery.NTSB NYC93LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodstown, PAThe pilot's improperly planned approach and delayed decision to initiate a go-around, which resulted in a touchdown too FAR down the runway and the subsequent collision with a ditch. A factor related to the accident was the pilot's lack of recent flight…NTSB NYC93LA032Accident · Minor injuriesLimited investigationFinal reportLet LF-13 · Readington, NJThe pilot's poorly planned approach for landing which resulted in an off airport landing in unsuitable terrain.NTSB LAX93WA028Accident · 1 fatalForeign investigationde Havilland DHC-6-200 · KenyaNTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.NTSB SEA93LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Ashton, IDA power loss for undetermined reasons. A factor contributing to the accident was the soft terrain.NTSB NYC93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mt. Gilead, OHPilot incapacitation due to carbon monoxide gas as a result of cracks in the heater muffler. A factor in the accident was the progressive deterioration of the left heater muffler.NTSB LAX93LA022Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Sierra Vista, AZThe flight's encounter with unforecast unfavorable winds.NTSB LAX93LA021Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Gonzales, CAThe pilot's failure to maintain adequate clearance from the wires.NTSB LAX93FA024Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Kelso, CAThe pilot's poor preflight planning; his inadequate weather evaluation; and his intentional VFR flight into instrument meteorological conditions. Contributing to the accident was the turbulence, rain and low clouds.NTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.NTSB CHI93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Ft. Riley, KSThe non-current student pilot's failure to maintain adequate clearance from terrain while operating at night, in instrument meteorological conditions.NTSB ATL93LA020Accident · No injuriesLimited investigationFinal reportMaule M4-210C · Pickens, SCThe pilot's failure to follow normal before takeoff procedures which included placing the propeller lever in the high RPM low pitch position. The pilot also delayed in aborting the takeoff attempt and applied hard braking which resulted in a nose over.NTSB ATL93LA019Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rives, TNThe pilot's failure to follow instrument procedures while conducting an instrument approach which resulted in the collision with trees; the pilot descended below the minimum descent altitude.NTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.NTSB LAX93FA020Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Cottonwood, AZAn inadvertent stall and descent into terrain when the pilot failed to maintain sufficient airspeed and altitude above the ground.NTSB BFO93LA002Accident · No injuriesLimited investigationFinal reportBeech B24R · Waynesburg, PAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from the terrain/obstructions. Factors related to the accident were the pilot's lack of a preflight weather briefing, and the…NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.NTSB NYC93LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Mallory, WVThe pilot failed to maintain control of the airplane, which resulted in the airplane departing the runway and striking a tree.NTSB MIA93WA068Accident · Minor injuriesForeign investigationHughes 369D · Buenos Aires, ArgentinaNTSB LAX93FA045Accident · 2 fatalField investigationFinal reportBeech D50A · Ely, NV1) The pilots decision to attempt VFR flight into instrument meteorological conditions, which included mountain obscurement and severe mixed icing, and, 2) his failure to maintain control of the aircraft due to a probable aerodynamic stall induced by severe…NTSB FTW93WA030Accident · No injuriesForeign investigationPiper PA-31-325 · Barranquilla, Colombia