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.

NTSB MIA92LA076Accident · Minor injuriesLimited investigationFinal reportAero Mercantil Gavilan 358 EL-1 · Columbus, MSFatigue failure of the crankshaft due to improper engine assembly by the manufacturer.Feb 1, 1992 · N3500Z · Substantial damageNTSB MIA92IA075Incident · No injuriesIncident investigationFinal reportPiper PA-28-180 · Destin, FLImproper procedures/directives by the pilot-in-command while attempting to restart the engine, resulting in the engine compartment fire.Feb 1, 1992 · N7909W · Minor damageNTSB FTW92FA064Accident · 2 fatalField investigationFinal reportCessna 182 · Bartlesville, OKThe pilot's failure to maintain terrain clearance. A factor was the dark night.Feb 1, 1992 · N6444A · DestroyedNTSB DEN92LA029Accident · Minor injuriesLimited investigationFinal reportWarfield BD-4 · Englewood, COImproper vr speed used, causing an inadvertent stall/mush. A factor was: the pilot's lack of total experience in aircraft make and model.Feb 1, 1992 · N689W · DestroyedNTSB ATL92FA042Accident · No injuriesField investigationFinal reportCessna T210L · Georgetown, SCThe failure of overhaul personnel to properly torque the engine case rear thru bolts.Feb 1, 1992 · N732HG · Substantial damageNTSB MIA92LA073Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Alpha · Juno Beach, FLImproper collective and cyclic control inputs and poor in-flight planning decision by the pilot-in-command.Jan 31, 1992 · N85570 · Substantial damageNTSB FTW92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Canyon Lake, TXThe pilot's failure to properly monitor his fuel consumption and his failure to divert to an alternate airport prior to running out of gas.Jan 31, 1992 · HK369 · Substantial damageNTSB FTW92DQA01Accident · 1 fatalFinal reportAir Trans. White Lightning · Aztec, NMThe inadvertent stall and the pilot's lack of experience in the accident aircraft.Jan 31, 1992 · N121WE · DestroyedNTSB CHI92FA084Accident · 3 fatalField investigationFinal reportPiper PA-31T · Swanton, OHLoss of aircraft control for an undetermined reason.Jan 31, 1992 · N6038A · DestroyedNTSB SEA92FA105Accident · 1 fatalField investigationFinal reportCessna 182R · Garrison, MTPoor inflight planning/decision. Factors to the accident were: icing conditions, dark night, flight into known adverse weather and an inadequate weather evaluation.Jan 30, 1992 · N8267E · DestroyedNTSB SEA92FA041Accident · 2 fatalField investigationFinal reportPiper PA-23-180 · Gold Bar, WAThe pilot becoming inadvertently lost/disoriented. The environmental conditions were factors in the accident.Jan 30, 1992 · CFDFV · DestroyedNTSB MIA92FA072Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Malabar, FLA divergence of the main rotor from its normal plane of rotation for an undetermined reason which resulted in mast bumping and a main rotor blade contact with the cockpit area.Jan 30, 1992 · N2313G · DestroyedNTSB LAX92T#A02Accident · No injuriesClass 3Final reportPiper J3 · San Carlos, AZJan 30, 1992 · N2BM · Substantial damageNTSB BFO92LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Baltimore, MDThe failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.Jan 30, 1992 · N9103Q · Substantial damageNTSB BFO92LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · West Hempstead, NYLoss of engine power for an unknown reason. The lack of suitable terrain for an emergency landing was a related factor.Jan 30, 1992 · N7673U · Substantial damageNTSB MIA92WA071Accident · No injuriesForeign investigationPiper PA-34-200 · West End, BahamasJan 29, 1992 · N1034U · DestroyedNTSB MIA92FA070Accident · 3 fatalField investigationFinal reportCessna 337 · Moore Haven, FLThe pilot-in-command's in flight loss of control due to spatial disorientation. Contributing to the accident was the pilot-in-command's lack of total experience in night flight, and the lack of natural horizon or surface reference while flying over a sparsely…Jan 29, 1992 · N2211X · DestroyedNTSB LAX92LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Cottonwood, AZThe student pilot's failure to maintain airspeed and premature raising of the flaps. Contributing to this accident was the improper recovery from a bounced landing, lack of total experience, and the inadvertent stall.Jan 29, 1992 · N6087D · Substantial damageNTSB 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.Jan 29, 1992 · N65603 · Substantial damageNTSB FTW92FA061Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Oklahoma City, OKThe second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.Jan 29, 1992 · N4869V · Substantial damageNTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.Jan 29, 1992 · N8379N · DestroyedNTSB LAX92LA105Accident · 1 fatalLimited investigationFinal reportCessna 170B · Austin, NVThe pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…Jan 28, 1992 · N39HP · Substantial damageNTSB ANC92IA030Incident · No injuriesIncident investigationFinal reportPiper PA-31-T3 · Anchorage, AKThe pilot's continued taxi after becoming lost or disoriented. Factors relating to the accident were the whiteout conditions caused by the freshly falling and blowing snow and the inadequate snow removal by airport personnel.Jan 28, 1992 · N314SC · Minor damageNTSB MIA92LA069Accident · No injuriesLimited investigationFinal reportBell 47D1 · Cross City, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.Jan 27, 1992 · N93067 · Substantial damageNTSB DEN92LA027Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COA loss of control due to the pilot's failure to follow proper soft field takeoff procedures by flying out of ground effect at an inadequate airspeed. A factor was the pilot's improper use of flaps.Jan 27, 1992 · N52872 · Substantial damageNTSB LAX92LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ft Mojave, AZAn inadequate annual inspection performed by other maintenance personnel. Contributing to this accident was the flap cable failure due to corrosion.Jan 26, 1992 · N23455 · Substantial damageNTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.Jan 26, 1992 · N5842G · Substantial damageNTSB CHI92IA079Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355F1 · Lansing, MIA fatigue failure of a fuel system line fitting during cruise flight.Jan 26, 1992 · N101UM · Minor damageNTSB BFO92FA025Accident · 1 fatalField investigationFinal reportBeech V35B · Manassas, VAThe pilot's failure to remove ice from the wings during the preflight inspection which resulted in a stall during takeoff due to ice on the wings.Jan 26, 1992 · N3738A · DestroyedNTSB LAX92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Tonopah, NVThe pilot's failure to assure that there was an adequate supply of fuel in the airplane to complete the flight due to alcoholic impairment of efficiency and judgement resulting in a total loss of power of both engines.Jan 25, 1992 · N7325L · Substantial damageNTSB LAX92FA102Accident · 4 fatalField investigationFinal reportPiper PA28-161 · Mountain Pass, CAThe pilots failure to maintain the aircraft's airspeed above the stall speed (vs) that resulted in an inadvertent entry into a stall/spin.Jan 25, 1992 · N8432K · DestroyedNTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.Jan 25, 1992 · N88ES · Substantial damageNTSB CHI92LA081Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Minneapolis, MNA misjudged autorotation.Jan 25, 1992 · N4046H · Substantial damageNTSB CHI92LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEThe pilot's inadequate compensation for the wind conditions. Associated factors are the high and gusty winds.Jan 25, 1992 · N96722 · Substantial damageNTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.Jan 25, 1992 · N6225G · Substantial damageNTSB MIA92FA067Accident · 2 fatalField investigationFinal reportCessna 402-C · Clewiston, FLPilot-in-command's improper inflight decision to attempt to descend and remain in VFR conditions in an area of thunderstorms and heavy rain. Contributing to the accident was the pilot-in-command's loss of control in flight.Jan 24, 1992 · N2714A · DestroyedNTSB LAX92LA100Accident · Serious injuriesLimited investigationFinal reportJames Houston KR2 · Chandler, AZThe pilot's improper emergency procedures, misjudging the airplane's altitude, failure to attain the proper touchdown point and excessive airspeed. Contributing to this accident was an undetermined loss of power and the pilot's lack of familiarity with the…Jan 24, 1992 · N87JJ · DestroyedNTSB MIA92WA066Accident · 2 fatalForeign investigationBeech B-99 · DominicaJan 23, 1992 · N42AK · DestroyedNTSB MIA92LA068Accident · 3 fatalLimited investigationFinal reportPiper PA-32-301 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane crashed in the Atlantic Ocean and was not located.Jan 23, 1992 · N8300X · DestroyedNTSB MIA92IA065Incident · No injuriesIncident investigationFinal reportBoeing 757-23APF · Miami, FLThe pilot-in-command's improper supervision of the co-pilot/first officer. This resulted in a total loss of engine power on both engines while at low power settings in known icing conditions for failure to follow checklist procedures.Jan 23, 1992 · N572CA · No damageNTSB LAX92LA099Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Pacoima, CAThe pilot's improper preflight and delay in aborting the takeoff. Contributing to this accident was the unlocked nose baggage door.Jan 23, 1992 · N8662Y · Substantial damageNTSB BFO92LA024Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbus, OHFuel starvation in both engines, due to the pilot's improper positioning of the engine or fuel controls.Jan 23, 1992 · N8434H · Substantial damageNTSB FTW92LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXFouled spark plugs, loose spark plug ignition lead, exhaust leak, and cylinder leak. Factors were an inadequate annual inspection, poor maintenance, and operation by the pilot with known mechanical deficiencies.Jan 22, 1992 · N107EH · Substantial damageNTSB FTW92LA058Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Austin, TXThe pilot's failure to maintain proper altitude. Factors were the pilot descending below the minimum descent altitude and not performing the briefed missed approach procedure along with the dark night, fog, drizzle, and low ceiling.Jan 22, 1992 · N201YR · Substantial damageNTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.Jan 22, 1992 · N35308 · Substantial damageNTSB LAX92LA097Accident · No injuriesLimited investigationFinal reportCessna 120 · Sonoma, CAEngine failure due to a binding mixture control shaft. The binding mixture control shaft was the result of inadequate maintenance which allowed the accumulation of moisture and water in the carburetor to remain for an extended period of time causing rust and…Jan 21, 1992 · N3010N · Substantial damageNTSB LAX92LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Boulder, NVThe student pilot's failure to maintain directional control of the airplane during the takeoff portion of a touch an go landing. A factor which contributed to the accident was the student's lack of experience in the type of operation.Jan 20, 1992 · N5445N · Substantial damageNTSB DCA92RA019Accident · No injuriesForeign investigationAirbus Industrie A320 · Strasburg, FranceJan 20, 1992 · FGGEDNTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.Jan 20, 1992 · N152BA · Substantial damageNTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.Jan 19, 1992 · N2742R · Minor damage