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 CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.Mar 24, 1991 · N447MR · Substantial damageNTSB BFO91LA034Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Buchanan, VAThe pilot's decision to attempt the takeoff with unfavorable winds.Mar 24, 1991 · N2451W · Substantial damageNTSB NYC91LA092Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Westbrook, MEImproper emergency procedures by the pilot. Factors related to the accident were: the pilot's lack of experience and flight time in type of airplane, the pilots decision to take an airplane with a known mechanical defect, a leaky accelerator pump seal on the…Mar 23, 1991 · N4155P · Substantial damageNTSB MIA91LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Clewiston, FLMisjudged wind direction resulting in incorrect runway selection and failure by the PIC to initiate a go-around after landing with a tailwind. Contributing to the accident was the lack of the pilot's total experience.Mar 23, 1991 · N739BW · Substantial damageNTSB MIA91LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe loss of control on the ground by the student pilot due to a lack of total experience and apprehension on his first solo flight.Mar 23, 1991 · N440FT · Substantial damageNTSB LAX91LA144Accident · No injuriesLimited investigationFinal reportHelio H391B · Prescott, AZThe pilot's failure to maintain directional control and improper use of the flight controls. Contributing to this accident was the cross wind and soft terrain, and the pilot's lack of experience in the airplane.Mar 23, 1991 · N289LM · Substantial damageNTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.Mar 23, 1991 · N4071L · Substantial damageNTSB LAX91LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Phoenix, AZThe decision of the flight instructor to conduct a simulated power failure emergency in a manner which was inappropriate.Mar 23, 1991 · N1805X · Substantial damageNTSB CHI91LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 727-222 · Buffalo, NYA clear air turbulence encounter.Mar 23, 1991 · N7449U · No damageNTSB CHI91LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Wichita, KSDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. Factors related to the accident were a gusty crosswind and a drainage ditch.Mar 23, 1991 · N96868 · Substantial damageNTSB LAX91LA147Accident · 1 fatalLimited investigationFinal reportde Havilland DHC6-300 · Nuuuli, AntarcticaThe inadequate lighting of the gate at the terminal and inadequate training of the security guard by company personnel. Contributing to this accident was a dark night condition.Mar 22, 1991 · 5WFAU · No damageNTSB LAX91LA140Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58J · Chowchilla, CA1) The pilot not following the performance data for the aircraft, and 2) the pilot's inflight decision to turn the aircraft, which was at or near maximum gross weight, in such a direction that required more power than was available for the given flight…Mar 22, 1991 · N27AR · Substantial damageNTSB LAX91FA173Accident · 4 fatalField investigationFinal reportCessna 182F · Young, AZThe pilot's inadequate in-flight decision to continue VFR flight into instrument meteorological conditions and the loss of control of the airplane resulting in an inflight collision with terrain.Mar 22, 1991 · N3458U · DestroyedNTSB FTW91FA055Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Pasadena, TXPower loss due to fuel exhaustion resultant from the pilot's failure to refuel at an alternate destination and the inadvertent stall. Factors were the dark night and weather conditions.Mar 22, 1991 · N888G · DestroyedNTSB BFO91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 152 · California, MDThe loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with terrain.Mar 22, 1991 · N757PH · DestroyedNTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.Mar 22, 1991 · N5241D · Substantial damageNTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…Mar 22, 1991 · N7523C · DestroyedNTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.Mar 21, 1991 · N4117N · DestroyedNTSB LAX91FA139Accident · Serious injuriesField investigationFinal reportBeech 55 · Burbank, CAThe pilot misjudged the liftoff speed, and prematurely rotated the aircraft for takeoff.Mar 21, 1991 · N711RY · DestroyedNTSB CHI91LA119Accident · No injuriesLimited investigationFinal reportCessna 182P · Loup City, NEThe pilot's improper landing/touchdown. A related factor was the pilot's lack of total flight experience.Mar 21, 1991 · N91376 · Substantial damageNTSB CHI91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IADelayed initiation of remedial action by the flight instructor. Factors related to the accident are gusty crosswinds, inadequate compensation for wind conditions and not maintaining airspeed by the student pilot, and complacency by the instructor.Mar 21, 1991 · N26009 · Substantial damageNTSB ANC91T#A01Accident · Minor injuriesClass 3Final reportCessna A185F · Galena, AKMar 21, 1991 · N735HB · Substantial damageNTSB MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.Mar 20, 1991 · N25459 · Substantial damageNTSB LAX91FA138Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Vacaville, CAThe pilot's continued VFR flight at night under low clouds, and his failure to maintain sufficient altitude over rising terrain. Factors related to the accident were: darkness, the adverse weather and terrain conditions, and the controller's inaccurate…Mar 20, 1991 · N2776M · DestroyedNTSB FTW91LA054Accident · No injuriesLimited investigationFinal reportCessna 210 · New Orleans, LAThe power loss due to fatigue induced crankshaft failure. Factors were the pilot's continued operation with known mechanical malfunction and the lack of suitable terrain for the forced landing.Mar 20, 1991 · N219CG · Substantial damageNTSB ATL91LA068Accident · No injuriesLimited investigationFinal reportCessna 210G · Metter, GAThe pilot's failure to extend the landing gear when his attention was diverted by radio conversation.Mar 20, 1991 · N28CE · DestroyedNTSB ANC91LA036Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Moose Creek, AKThe pilot-in-command's failure to maintain aircraft control, proper altitude not maintained, and failure to maintain flying speed. Contributing to the accident was the high altitude terrain.Mar 20, 1991 · N3419M · Substantial damageNTSB MIA91LA103Accident · No injuriesLimited investigationFinal reportCessna 150L · Miami, FLTotal loss of engine power due to inadvertent use of the mixture control by the student, inadequate supervision by the CFI, and delayed remedial action by the CFI resulting in the off airport landing.Mar 19, 1991 · N10629 · Substantial damageNTSB LAX91LA137Accident · No injuriesLimited investigationFinal reportSikorsky H-19/S55 · Richvale, CAThe failure of the engine's number 4 cylinder intake valve keeper. Trees under the helicopter at the time of the loss of engine power were factors in the accident.Mar 19, 1991 · N9894 · Substantial damageNTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.Mar 19, 1991 · N17687 · Substantial damageNTSB CHI91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Morgan, MNA guy wire was struck on takeoff because of inadequate clearance. Factors related to the accident were poor planning/decision by the pilot and over confidence in personal ability.Mar 19, 1991 · N4338C · Substantial damageNTSB NYC91LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Leroy, NYThe hard landing made by the pilot. Factors relating to the accident were the decision of the pilot to land on the runway despite the runway lighting system being partially inoperative, and the lack of experience of the pilot at night.Mar 18, 1991 · N20360 · Substantial damageNTSB MIA91RA102Accident · 5 fatalForeign investigationCessna 402C · Treasure Cay, BahamasMar 18, 1991 · N5785CNTSB LAX91LA135Accident · No injuriesLimited investigationFinal reportMooney M20D · Herlong, CAThe inadequate preparation of the propeller during overhaul. The installation of an improper pitched propeller and the fatigue failure of the propeller blade emanating from corrosion were factors in the accident.Mar 18, 1991 · N1921Y · Substantial damageNTSB DEN91LA053Accident · Serious injuriesLimited investigationFinal reportRockwell 112B · Nederland, CODeteriorated ignition harness and ignition lead arcing. Factors were the high density altitude and lack of suitable terrain for the forced landing.Mar 18, 1991 · N1241J · Substantial damageNTSB DEN91LA052Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Spring, COThe pilot's failure to maintain directional control of the aircraft. The gusty/quartering crosswind was a related factor.Mar 18, 1991 · N1950Q · Substantial damageNTSB CHI91FA108Accident · 4 fatalField investigationFinal reportPiper PA-30 · Thief River Fls, MNImproper IFR procedure of the pilot, while intercepting the ILS localizer, by not maintianing the minimum descent altitude (mda) for that segment of the approach.Mar 18, 1991 · N8290Y · DestroyedNTSB BFO91LA032Accident · No injuriesLimited investigationFinal reportPiper PA32-260 · Roanoke, VAThe pilot's failure to maintain terrain clearance on a night visual approach.Mar 18, 1991 · N4870T · Substantial damageNTSB ATL91FA067Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Hamilton, NCThe pilot's improper use of equipment which affected the operation of the standby vacuum pump, the pilot's loss of aircraft control after experiencing spatial disorientation, and his exceeding the design stress limits of the aircraft. Factors related to the…Mar 18, 1991 · N2871H · DestroyedNTSB ANC91IA037Incident · No injuriesIncident investigationFinal reportBeech C-45H · Shageluk, AKThe accident was the pic's failure to properly determine the required width of runway needed by their airplane and inadequate snow removal. Contributing to the accident was the snow berm and the copilot's misjudgment of runway width.Mar 18, 1991 · N400WA · Minor damageNTSB SEA91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Pullman, WAThe pilot's encounter with wake turbulence shortly before touchdown, resulting in a hard landing.Mar 17, 1991 · N2455N · Substantial damageNTSB NYC91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phillipsburg, PACarburetor ice and the pilot's improper use of carburetor heat. Factors related to the accident were: the carburetor icing (weather) conditions and the lack of suitable terrain for a forced landing.Mar 17, 1991 · N4510A · Substantial damageNTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…Mar 17, 1991 · N9112K · DestroyedNTSB FTW91DRD03Accident · No injuriesFinal reportGrumman G-164A · Bonita, LAA power loss due to a cracked cylinder. A factor was the soft terrain in which the forced landing was performed.Mar 17, 1991 · N9685 · Substantial damageNTSB CHI91LA110Accident · No injuriesLimited investigationFinal reportBoeing A75 · North Platte, NEDirectional control was not maintained by the pilot resulting in a swerve and ground loop. A factor related to the accident was lack of total experience in type of aircraft by the pilot.Mar 17, 1991 · N4968V · Substantial damageNTSB SEA91LA067Accident · No injuriesLimited investigationFinal reportClyde L. King Osprey II · Aurora, ORA loss of engine power due to fuel starvation because of an inadequate component and inadequate fuel system design.Mar 16, 1991 · N69CK · Substantial damageNTSB LAX91LA136Accident · No injuriesLimited investigationFinal reportCessna T207A · Las Vegas, NVFuel exhaustion due to fuel siphoning in flight from an unsecured filler cap. The inaccurate preflight inspection of the aircraft by the pilot was also causal in this accident.Mar 16, 1991 · N75841 · Substantial damageNTSB LAX91FA134Accident · 2 fatalField investigationFinal reportCessna 172RG · Buckeye, AZThe pilot of the airplane exceeding the certificated never exceed velocity. The overloading of the wing attachment fittings while maneuvering was a factor in the accident.Mar 16, 1991 · N6439 · DestroyedNTSB LAX91FA132Accident · 10 fatalField investigationFinal reportHawker Siddeley DH.125-1A/522 · San Diego, CAImproper planning/decision by the pilot, the pilot's failure to maintain proper altitude and clearance over mountainous terrain, and the copilot's failure to adequately monitor the progress of the flight. Factors related to the accident were: insufficient…Mar 16, 1991 · N831LC · DestroyedNTSB FTW91LA050Accident · No injuriesLimited investigationFinal reportHughes 269A · Addison, TXThe pilot's failure to maintain directional control during landing.Mar 16, 1991 · N62269 · Substantial damage