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 ATL94LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Raleigh, NCThe pilot's inadequate in-flight fuel planning that resulted in fuel starvation.Apr 15, 1994 · N6380W · DestroyedNTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…Apr 15, 1994 · N39770 · DestroyedNTSB SEA94FA100Accident · 2 fatalField investigationFinal reportCessna 182Q · The Dalles, ORAn inflight loss of control for undetermined reasons.Apr 14, 1994 · N4887N · DestroyedNTSB ATL94LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Barnwell, SCThe pilot's failure to flare properly which resulted in a hard landing.Apr 14, 1994 · N61990 · Substantial damageNTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.Apr 13, 1994 · N2728K · Substantial damageNTSB MIA94LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Crescent City, FLThe pilot's improper descent rate, and the check pilot's inadequate supervision. The glassy water condition was a factor.Apr 13, 1994 · N8196G · Substantial damageNTSB MIA94LA120Accident · No injuriesLimited investigationFinal reportPitts S1-C · Lakeland, FLThe pilot-in-command's failure to maintain proper runway alignment during a crosswind landing.Apr 13, 1994 · N16LW · Substantial damageNTSB LAX94LA188Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Willcox, AZEngine power loss due to fuel contamination as a result of inadequate inspection of the fuel and fuel system.Apr 13, 1994 · N5827U · Substantial damageNTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.Apr 13, 1994 · N9086V · DestroyedNTSB SEA94LA098Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Troutdale, ORThe instructor pilot's inadequate remedial action. Factors include the dual student's lack of experience, and his failure to maintain directional control. Another factor was unfavorable, gusty winds.Apr 12, 1994 · N2865B · Substantial damageNTSB BFO94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poughkeepsie, NYThe student pilot's failure to maintain control of the airplane immediately after engine start, and his delay in reducing power and applying the brakes.Apr 12, 1994 · N5962U · Substantial damageNTSB ATL94LA080Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Latta, SCThe pilot's failure to obtain flying speed and the premature lift off which resulted in a stall.Apr 12, 1994 · N4856Q · Substantial damageNTSB LAX94LA186Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Elko, NVthe student pilot's improper use of the throttle and flap controls during a bounced landing recovery, and, his failure to maintain an adequate airspeed, which led to an inadvertent stall/spin.Apr 11, 1994 · N54006 · Substantial damageNTSB CHI94LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Edina, MOthe pilot in commands' failure to obtain obstruction clearance from trees during a visual takeoff from a short, soft, wet field in instrument meteorological conditions. A factor was the pilot in commands' misjudgment of the takeoff climb performance of the…Apr 11, 1994 · N4253L · DestroyedNTSB CHI94LA130Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Chesterfield, MOFailure of the pilot to follow proper IFR procedures and maintain proper altitude during the approach. Factors related to the accident were: darkness, the weather conditions, and failure of the approach controller to issue an IFR transponder code to the…Apr 11, 1994 · N9187M · DestroyedNTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.Apr 11, 1994 · N11560 · Substantial damageNTSB MIA94LA119Accident · No injuriesLimited investigationFinal reportGlobe 9C-1B · Okeechobee, FLBoth pilots misjudged their clearance from each other.Apr 10, 1994 · N78321 · 2 aircraft · Substantial damageNTSB MIA94LA118Accident · No injuriesLimited investigationFinal reportCessna 310J · Ocala, FLFailure of the pilot to assure the generators were engaged before flight (failed to follow the checklist).Apr 10, 1994 · N310JF · Substantial damageNTSB MIA94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · River Ranch, FLThe improper inspection of the worn throttle linkage connection at the fuel control, which resulted in the linkage becoming disconnected from the fuel control in flight and the engine losing power. This resulted in the aircraft colliding with a ditch during a…Apr 10, 1994 · N1395T · Substantial damageNTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.Apr 10, 1994 · N39125 · Substantial damageNTSB LAX94LA201Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The low altitude of the aircraft when the engine lost power and the pilot's misjudgement of the flare point during the autorotation. Factors in the accident were the loss of engine power and the sunglare.Apr 10, 1994 · N60718 · Substantial damageNTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.Apr 10, 1994 · N6319M · 2 aircraft · Substantial damageNTSB ANC94LA044Accident · No injuriesLimited investigationFinal reportPiper J3 · Denali Nat'L Pk, AKThe failure of the landing gear bolt attachment fitting due to fatigue.Apr 10, 1994 · N37932 · Substantial damageNTSB SEA94LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hurricane, UTThe pilot in command's failure to refuel and excessive airspeed during the approach. Factor(s) were: fencepost(s) and the lack of recent experience in type of aircraft.Apr 9, 1994 · N4480P · Substantial damageNTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.Apr 9, 1994 · N757KN · 2 aircraft · DestroyedNTSB LAX94FA185Accident · 1 fatalField investigationFinal reportCessna 172N · Julian, CAImproper planning/decision by the pilot(s). Factors related to the accident were: the high/mountainous terrain and adverse weather conditions.Apr 9, 1994 · N6242D · DestroyedNTSB FTW94LA122Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Mount Bellvue, TXThe pilot's failure to maintain directional control. Factors were the soft runway and gusty winds.Apr 9, 1994 · N3628T · Substantial damageNTSB BFO94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gloucester, VAThe pilot-in-command's failure to perform adequate pre-flight inspections and planning for the flight, and his failure to refuel the airplane. This led to fuel exhaustion of the engine and a forced landing.Apr 9, 1994 · N857DG · Substantial damageNTSB ATL94LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Collegedale, TNThe pilot's failure to compensate for wind conditions during a crosswind landing. The crosswind was a factor.Apr 9, 1994 · N6639C · Substantial damageNTSB ANC94LA045Accident · No injuriesLimited investigationFinal reportHiller UH12E · Valdez, AKThe inadvertent closure of the fuel supply shutoff valve.Apr 9, 1994 · N87594 · Substantial damageNTSB MIA94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Boca Raton, FLThe failure of the dual student to maintain directional control during landing and the failure of the flight instructor to properly supervise the dual student and take corrective action in a timely manner.Apr 8, 1994 · N32056 · Substantial damageNTSB LAX94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kerman, CAAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, incapacition of the pilot, and loss of aircraft control.Apr 8, 1994 · N9124G · Substantial damageNTSB FTW94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Englewood, COA loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Apr 8, 1994 · N881GK · DestroyedNTSB CHI94LA129Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Hebron, NEThe failure of the student pilot to maintain adequate clearance from obstructions during aerial taxi.Apr 8, 1994 · N100LU · Substantial damageNTSB ANC94LA048Accident · No injuriesLimited investigationFinal reportCessna A185F · Paxson, AKThe pilot-in-command did not maintain proper clearance from the snow berm. A factor in the accident was the snow berm.Apr 8, 1994 · N8191Q · Substantial damageNTSB ANC94LA046Accident · No injuriesLimited investigationFinal reportHelio 295 · Manley Hot Sprg, AKFuel starvation caused by a blocked fuel vent line. A factor in the accident was the improper aircraft preflight.Apr 8, 1994 · N42DC · Substantial damageNTSB MIA94FA114Accident · 1 fatalField investigationFinal reportPiper PA-12 · Merritt Island, FLThe loss of elevator control due to jamming by the tow rope which prevented the pilot from being able to control the airplane.Apr 7, 1994 · N2834M · Substantial damageNTSB BFO94LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Clarksburg, WVthe pilot's selection of a downwind runway, and his inadequate compensation for the wind conditions. A factor was the gusting tailwind.Apr 7, 1994 · N739HC · Substantial damageNTSB ATL94LA077Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Memphis, TNNot Determined.Apr 7, 1994 · N306FE · Minor damageNTSB ATL94FA076Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Elizabethton, TNThe pilot's attempted VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the clouds and obscuration at the accident site.Apr 7, 1994 · N64LB · DestroyedNTSB ATL94FA075Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Smithville, TNThe pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.Apr 7, 1994 · N9710C · DestroyedNTSB MIA94LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Tallahassee, FLThe pilot-in-command's improper compensation for wind conditions and lack of rudder input during an attempted go-around that resulted in loss of control in flight and collision with terrain. Rudder input was needed to compensate for the p-factor generated by…Apr 6, 1994 · N2477E · Substantial damageNTSB MIA94LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Pompano Beach, FLThe student pilot's improper recovery from a bounced landing, resulting in a porpoise of the aircraft and nose gear collapse.Apr 6, 1994 · N24737 · Substantial damageNTSB LAX94LA182Accident · 1 fatalLimited investigationFinal reportCessna 152 · Avalon, CAthe failure of the pilot to apply carburetor heat as appropriate while conducting flight in conditions conducive for carburetor icing. A factor in the accident was the unsuitable steep mountainous terrain for a forced landing.Apr 6, 1994 · N93508 · DestroyedNTSB MIA94LA111Accident · No injuriesLimited investigationFinal reportMooney M20-J · Daytona Beach, FLCollapse of the left main landing gear for unknown reasons.Apr 5, 1994 · N187ER · Substantial damageNTSB LAX94LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sedona, AZthe pilot's inadequate compensation of the existing wind conditions, and failure to maintain directional control of the aircraft.Apr 5, 1994 · N35060 · Substantial damageNTSB LAX94LA178Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Chino, CAthe pilot's decision to fly an unairworthy and uncertificated airplane, his failure to perform an adequate preflight, and the improper installation of the oil cooler lines.Apr 5, 1994 · N1451D · DestroyedNTSB LAX94IA181Incident · Minor injuriesIncident investigationFinal reportFairchild SA-227AC · Ontario, CAthe failure of maintenance personnel to detect a crack in the windscreen which exceeded the operational limits for pressurized flight. A factor in the accident was the inadequacy of the inspection method published by the manufacturer.Apr 5, 1994 · N174SW · Minor damageNTSB FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.Apr 5, 1994 · N3094F · Substantial damageNTSB NYC94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · White Plains, NYThe partial loss of engine power as the result of a disconnected throttle cable, and the subsequent forced landing and ditching in water to avoid collision with trees.Apr 4, 1994 · N5335T · Substantial damage