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 NYC91LA242Accident · No injuriesLimited investigationFinal reportCessna 180L · Vestal, NYImproper use of carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB NYC91FA246Accident · 2 fatalField investigationFinal reportCessna 172P · West Chicago, ILThe pilot's improper in-flight decision to return to the airport following a loss of engine power at a low altitude. The pilot failed to maintain airspeed which resulted in an inadvertent stall at an altitude insufficient for recovery. Factors contributing to…NTSB MIA91LA223Accident · No injuriesLimited investigationFinal reportCentrair 101A · Groveland, FLThe pilot in command's poor in flight decision planning, and inadvertent stall mush while on approach to land. Contributing to the accident was his lack of total experience.NTSB MIA91LA222Accident · Serious injuriesLimited investigationFinal reportHoffmeyer Moni Standard · Brooksville, FLIncapacitation of the pilot in command and inadvertent stall mush.NTSB MIA91LA221Accident · 2 fatalLimited investigationFinal reportJohn H. Logan Loganair I · Gainesville, FLThe non-instrument rated pilot in command's decision to depart under special visual flight rule clearance in instrument flight rules conditions during darkness with a failed vacuum pump and resulting inoperative flight instruments which resulted in an…NTSB LAX91LA409Accident · No injuriesLimited investigationFinal reportCessna 206 · Jamul, CAThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident was the soft wet runway condition.NTSB LAX91LA402Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Buckeye, AZThe passenger/certified flight instructor's poor judgement by interfering with the PIC and his failure to execute a timely go-around. Contributing to this accident was the cfi's misjudgment of altitude.NTSB LAX91IA415Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Santa Ana, CAThe failure of the flight attendant assigned to the aft galley jumpseat to secure a beverage cart in accordance with company policy.NTSB LAX91FA401Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Placerville, CAThe pilot's attempted takeoff at a high density airport with the airplane exceeding its maximum gross takeoff weight. Contributing to the accident was the pilot's use of illegal drugs and abuse of prescription drugs.NTSB LAX91FA399Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Cupertino, CAThe pilot's failure to maintain the proper altitude, his improper inflight decision to attempt flight below the base of an overcast layer of clouds toward rising mountainous terrain and the flight's inadvertent entry into instrument meteorological conditions.…NTSB FTW91LA165Accident · 1 fatalLimited investigationFinal reportPiper PA-28-150 · Van Horn, TXThe pilot's failure to maintain control of the airplane. A factor was the pilot's lack of total experience.NTSB DEN91LA137Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Englewood, COA hard landing and inadvertent deployment of the balloon heater. A factor was: inadvertent entanglement of a load cable with the heater activation device.NTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB ATL91LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pleasant Grove, ALThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB ATL91FA176Accident · 2 fatalField investigationFinal reportCessna C-172N · Alabaster, ALThe pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.NTSB ANC91LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Stoney River, AKThe pilot's failure to attain a proper climb. Factors in the accident were: the pilot's lack of familiarity with the airplane, his inadequate training in that model airplane, his lack of total experience, his inflight planning/decision, his overconfidence in…NTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…NTSB NYC91LA241Accident · No injuriesLimited investigationFinal reportRobinson R22B · Wexford, PAThe pilot's improper procedures during a practice autorotation, and selection of unsuitable terrain. Contributing to the accident was a loss of engine power for undetermined reasons, at a low altitude.NTSB LAX91LA400Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · French Gulch, CAThe pilot's failure to refuel before departing on the accident flight. Contributing to this accident was the high vegetation and fuel exhaustion.NTSB LAX91LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-602P · Pago Pago, AntarcticaThe mechanical failure of the airplane's nose wheel/gear steering system. A contributing factor was the pilot's inability to maintain directional control following the loss of steering effectiveness.NTSB FTW91LA163Accident · 1 fatalLimited investigationFinal reportChampion 7-GCB · Frankston, TXThe ground person did not understand the verbal instructions.NTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…NTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.NTSB CHI91LA278Accident · No injuriesLimited investigationFinal reportCessna 310J · Sugar Grove, ILThe buckled nose landing gear retraction/extension gear drive tube. A factor in the accident was the pilot in command not having the landing gear inspected at the interval recommended by the manufacturer.NTSB CHI91IA297Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Detroit, MIInadequate maintenance inspection of the main landing gear actuator assembly by company maintenance personnel. A factor in the incident is inadequate design of the landing gear actuator by the manufacturer.NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.NTSB NYC91FA239Accident · 2 fatalField investigationFinal reportConvair CV-580 · Belvedere Ctr, VTFailure of the first officer (co-pilot) to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: the lack of two pilots in the cockpit,…NTSB CHI91LA295Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, INFailure of the pilot to maintain directional control during the takeoff ground run from a touch-and-go landing.NTSB ANC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, AKThe damage sustained when striking a rock during the previous takeoff roll which resulted in the main landing gear's collapse during landing.NTSB SEA91TL#02Accident · No injuriesClass 3Final reportHiller-Soloy UH-12E · Vernal, UTNTSB SEA91LA243Accident · No injuriesLimited investigationFinal reportDonald W. Sorrels Vans RV-6 · Kennewick, WAThe loss of power due to the pilot/builder's improper adjustment of the engine idle speed. A factor relating to the accident was the soft terrain at the accident site.NTSB NYC91LA240Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Slippery Rock, PAThe on ground collision with a farm vehicle during landing roll out.NTSB MIA91LA220Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Bay Springs, MSTotal loss of engine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encountered during the forced landing.NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB ANC91LA157Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Cantwell, AKThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA91LA242Accident · Serious injuriesLimited investigationFinal reportAeronca 7DC · Yellow Pine, IDImproper inflight planning/decision by the pilot, which resulted in inadvertent flight into a box canyon and subsequent collision with trees, when there was insufficient space to reverse course and the aircraft would not outclimb rising terrain. The terrain…NTSB SEA91LA238Accident · No injuriesLimited investigationFinal reportChampion 7EC · Coeur D'Alene, IDA blocked fuel system vent, and an inadequate aircraft preflight by the pilot. Rough terrain in the emergency landing area was a related factor.NTSB LAX91LA397Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Phoenix, AZThe pilot's improper remedial action. Contributing to this accident was the pilot's improper use of the brakes and rudder and his lack of experience in the accident airplane's make and model.NTSB FTW91LA162Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lewisville, TXLoss of control due to foreign object damage induced binding flight controls. A factor was improper maintenance.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB SEA91LA250Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Redmond, WAThe pilot's failure to maintain the proper rate of descent. A factor contributing to the accident was unfavorable winds.NTSB SEA91LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ellensburg, WAThe pilot's failure to maintain terrain clearance. Contributing to the accident was the pilot's overconfidence in the aircraft's ability, and flight in a box canyon where remedial action was not possible.NTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.NTSB SEA91LA237Accident · 1 fatalLimited investigationFinal reportCessna 170B · Curtis, WAA misjudged maneuver due to physical impairment by alcohol. Contributing to the accident was overconfidence in personal ability.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB DEN91FA130Accident · 3 fatalField investigationFinal reportCessna 182G · Elida, NMThe pilot's improper preflight planning/preparation for the flight and his subsequent flight into instrument meteorological conditions. A factor was: heavy fog and low ceiling.NTSB BFO91LA084Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Clifton Forge, VAThe pilot's misjudgement of altitude, distance and speed which resulted in landing overshoot.NTSB ANC91LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Telida, AKThe pilot getting disoriented during flight due to his inattentiveness, the airplane's low fuel level, the fss specialist's giving the pilot an incorrect heading to fly, poor radio communications between the fss and the pilot, the strong crosswind, and the…NTSB SEA91LA236Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kent, WAFailure of the pilot to maintain directional control and proper runway alignment during the landing and go-around (aborted landing). Factors related to the accident were: the pilot's improper flare and improper recovery from a bounced landing, which resulted…