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 ATL95FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Covington, TNThe pilot exceeded the design stress limits of the aircraft and subsequent overload failures of the stabilator and wing spars.Apr 8, 1995 · N6390C · DestroyedNTSB MIA95WA103Accident · No injuriesForeign investigationHawker Siddeley HS125 · Santo Domingo, Dominican RepublicApr 7, 1995 · N41953 · Substantial damageNTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.Apr 7, 1995 · N714WW · Substantial damageNTSB LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.Apr 7, 1995 · N7758S · Minor damageNTSB LAX95LA156Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZthe pilot's inadequate compensation for the prevailing wind conditions which resulted in an inadvertent ground loop. The crosswind and the pilot's lack of familiarity with the aircraft are factors in this accident.Apr 7, 1995 · N333JS · Substantial damageNTSB FTW95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waco, TXTotal loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.Apr 7, 1995 · N94534 · Substantial damageNTSB FTW95LA160Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orange, TXThe pilot's delayed landing flare. Factors were fuel exhaustion due to the pilot's failure to stop and refuel.Apr 7, 1995 · N68190 · Substantial damageNTSB FTW95LA159Accident · Serious injuriesLimited investigationFinal reportRobinson S-12 Airaile · Sugartown, LAA partial loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.Apr 7, 1995 · N53CR · DestroyedNTSB CHI95LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot misjudged the landing flare. Factors related to the accident were the dark light conditions and the pilot's lack of visual cues for the runway environment.Apr 7, 1995 · N757UV · Substantial damageNTSB CHI95IA119Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Chicago, ILthe inadequacy or deterioration of lubricating grease in the wheel bearing, which led to the total bearing failure and subsequent loss of the wheel. Factors were the insufficiently defined procedures for repacking the bearing, along with an insufficient…Apr 7, 1995 · N9090U · Minor damageNTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.Apr 7, 1995 · N20819 · DestroyedNTSB ANC95LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe flight instructor's inadequate remedial action. Factors include the dual student's failure to maintain directional control, and the rear pilot's station not having brakes installed.Apr 7, 1995 · N3680M · Substantial damageNTSB MIA95WA099Accident · No injuriesForeign investigationCessna U206G · Nassau, BahamasApr 6, 1995 · N756CW · DestroyedNTSB LAX95LA155Accident · No injuriesLimited investigationFinal reportCessna 172N · Phoenix, AZThe use of excessive break-away thrust by the Boeing 737 crew. A factor related to the accident was: improper planning/decision by the Cessna 172 pilot by accepting a clearance to taxi behind the Boeing 737 without assurance that the Boeing 737 crew would not…Apr 6, 1995 · N737AV · Substantial damageNTSB LAX95LA154Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Stanfield, AZthe pilot's failure to maintain an adequate visual lookout for, and clearance from, obstacles while conducting simulated aerial application operations.Apr 6, 1995 · N3105B · DestroyedNTSB FTW95LA157Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Midland, TXThe pilot's failure to maintain directional control.Apr 6, 1995 · N6700V · Substantial damageNTSB CHI95LA117Accident · No injuriesLimited investigationFinal reportLewis KR-2 · Ogallala, NEthe owner/builder's improper maintenance (installation). Factors were the carburetor reversed and the mixture control cable not secured.Apr 6, 1995 · N49TF · Substantial damageNTSB BFO95LA044Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Finksburg, MDloss of engine power for undetermined reasons. A related factor was the lack of suitable terrain.Apr 6, 1995 · N93874 · DestroyedNTSB BFO95LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Jeannette, PAthe failure of the magneto pinion gear failure, which resulted in a total loss of engine power during initial climbout over usuitable terrain.Apr 6, 1995 · N6539J · DestroyedNTSB ATL95LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Canton, GAThe student pilot's failure to maintain directional control during a crosswind landing.Apr 5, 1995 · N19375 · Substantial damageNTSB SEA95LA091Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Prospect, ORThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was wet grass.Apr 4, 1995 · N2269N · Substantial damageNTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.Apr 4, 1995 · N6114E · Substantial damageNTSB LAX95LA151Accident · Minor injuriesLimited investigationFinal reportAndris KR2 · Turlock, CAthe failure of the propeller attach bolt retaining cotter pin, and the pilot/builder's inadequate preflight inspection of the aircraft prior to the attempted flight.Apr 3, 1995 · N22955 · DestroyedNTSB FTW95LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Tijeras, NMFuel starvation due to foreign material partially blocking the fuel screen, and the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.Apr 3, 1995 · N4478H · Substantial damageNTSB FTW95IA156Incident · Minor injuriesIncident investigationFinal reportBoeing 727-276 · Dfw Airport, TXThe improper use of the evacuation slide by the flight attendant. A factor was the short in the number 1 engine fire warning system, which motivated the captain to order an evacuation.Apr 3, 1995 · XASIJ · Minor damageNTSB CHI95IA116Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Moline, ILthe defective weld and the subsequent in flight failure of the welded plug located in the piston of the roll spoiler actuator. The manufacturer's inadequate design is a related factor.Apr 3, 1995 · N828MA · No damageNTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.Apr 2, 1995 · N8276C · Substantial damageNTSB SEA95LA074Accident · Serious injuriesLimited investigationFinal reportMirsepasy VAN'S RV-6A · Renton, WAThe pilot's failure to recover from the bounced landing, and his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to maintain an adequate descent rate toward the runway.Apr 2, 1995 · N35EM · DestroyedNTSB NYC95LA083Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Jamaica, NYexcessive flames/tailpipe fire from the number 2 engine for an unknown reason, which required an emergency evacuation.Apr 2, 1995 · N1768D · No damageNTSB NYC95LA082Accident · No injuriesLimited investigationFinal reportCessna 150G · Dayton, OHthe pilot's inadequate preflight and inflight planning, resulting in fuel exhaustion and loss of engine power, and the subsequent nose over during a forced landing.Apr 2, 1995 · N6293S · Substantial damageNTSB MIA95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Venice, FLFailure of the globe GC-1B (swift) pilot to see the Piper PA-23 in time to avoid a collision, and the Piper PA-23 pilot's delay in initiating remedial action to avoid the collision.Apr 2, 1995 · N346PB · 2 aircraft · Minor damageNTSB LAX95LA153Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Healdsburg, CAthe instructor failed to adequately monitor the student pilot's actions and to react within the control margin necessary to successfully initiate a corrective action.Apr 2, 1995 · N2323K · Substantial damageNTSB FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.Apr 2, 1995 · N512E · Substantial damageNTSB FTW95FA151Accident · 1 fatalField investigationFinal reportBell 206L-1 · Flower Mound, TXThe pilot's improper wind evaluation, and improper touchdown procedure, resulting in dynamic rollover of the helicopter. Factors were the tailwind, dark night, and the lack of recent experience at night.Apr 2, 1995 · N701EC · Substantial damageNTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.Apr 2, 1995 · N4917Z · Substantial damageNTSB CHI95LA113Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Higginsville, MOthe pilot's inadequate compensation for wind conditions during the attempted takeoff. The gusty crosswind was a factor.Apr 2, 1995 · N2598Z · Substantial damageNTSB CHI95FA114Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Rush City, MNThe pilot's poor judgment in attempting to land in the existing wind conditions. His lack of experience was a factor.Apr 2, 1995 · N56349 · DestroyedNTSB BFO95LA039Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Bayport, NYThe pilot's improper positioning of the fuel selector.Apr 2, 1995 · N70234 · DestroyedNTSB NYC95LA084Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cairo, OHFailure of the pilot to maintain adequate airspeed after initiating a climb, which resulted in a stall/spin.Apr 1, 1995 · N9228R · DestroyedNTSB LAX95LA152Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Long Beach, CAthe failure and collapse of the left main landing gear due to a defective and improper weld by the manufacturer.Apr 1, 1995 · N111LS · Substantial damageNTSB FTW95LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Graham, TXThe pilot's failure to attain proper lift-off speed resulting in an inadvertent stall. Factors were the selection of the taxiway for take-off and the inoperative landing light.Apr 1, 1995 · N5426B · Substantial damageNTSB CHI95DCQ01Accident · 1 fatalFinal reportPitts S-2B · Ottawa, KSThe pilot not performing proper stall/spin recovery procedures.Apr 1, 1995 · N876CB · DestroyedNTSB BFO95LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Erie, PAThe loss of engine power for undetermined reasons.Apr 1, 1995 · N3546V · Substantial damageNTSB BFO95LA040Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lakewood, NJThe pilot's inadequate compensation for wind conditions and his inadequate evaluation of the weather conditions which resulted in an overrun. A factor is the sudden windshift.Apr 1, 1995 · N85713 · Substantial damageNTSB SEA95LA073Accident · No injuriesLimited investigationFinal reportFleet 7 · Arlington, WAThe pilot-in-command's improper use of the brakes. A factor was the failure to maintain directional control during landing rollout.Mar 31, 1995 · N432K · Substantial damageNTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.Mar 31, 1995 · N85094 · DestroyedNTSB MIA95RA097Accident · No injuriesForeign investigationCessna 185-F · Tegucigalpa, HondurasMar 31, 1995 · FAH12NTSB LAX95LA150Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · El Cajon, CAa loss of engine power due to an in-flight separation of the fuel system gascolator glass bowl resulting in a premature fuel exhaustion. The rough/uneven terrain is a factor in this accident.Mar 31, 1995 · N1937E · Substantial damageNTSB LAX95LA149Accident · No injuriesLimited investigationFinal reportBulsky Skybolt · Goodyear, AZfuel starvation due to the partial failure of the fuel pump caused by the broken crankshaft idler gear attachment screw lockplate. The unsuitable terrain and trees were factors in this accident.Mar 31, 1995 · N94BV · DestroyedNTSB FTW95LA152Accident · No injuriesLimited investigationFinal reportCessna 195A · Albuquerque, NMA partial failure of the airplane brake system (left brake). A factor was the right quartering tailwind.Mar 31, 1995 · N1048D · Substantial damage