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 FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.Jul 30, 1992 · N7642R · Substantial damageNTSB DCA92MA044Accident · Serious injuriesClass 1 · MajorFinal reportLockheed L-1011-385-1 · Jamaica, NYDesign deficiencies in the stall warning system that permitted a defect to go undetected, the failure of twa's maintenance program to correct a repetitive malfunction of the stall warning system, and inadequate crew coordination between the captain and first…Jul 30, 1992 · N11002 · DestroyedNTSB CHI92FA219Accident · 1 fatalField investigationFinal reportTeal TSC-1A2 · Oshkosh, WIThe pilot-in-command's not following procedures/directives.Jul 30, 1992 · N76TJ · Substantial damageNTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.Jul 30, 1992 · N1073P · Substantial damageNTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.Jul 30, 1992 · N4495Q · Substantial damageNTSB ANC92FA116Accident · 6 fatalField investigationFinal reportDe Havilland DHC-2 Mark 1 · Dillingham, AKThe pilot's delayed decision in reversing course and his failure to maintain airspeed during the maneuver. Factors related to the accident were: mountainous terrain and a low ceiling.Jul 30, 1992 · N67151 · DestroyedNTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.Jul 29, 1992 · N4906N · Substantial damageNTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.Jul 29, 1992 · N303VK · Substantial damageNTSB SEA92LA168Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Brigham City, UTA partial power loss for undetermined reasons and the pilot in command's inability to execute corrective action during the noseover. A factor contributing to the accident was the berm.Jul 29, 1992 · N55625 · Substantial damageNTSB MIA92LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Valkaria, FLExcessive airspeed on final approach by the pilot in command resulting in failure to attain the proper touchdown point and running off the runway colliding with a tree.Jul 29, 1992 · N89900 · Substantial damageNTSB MIA92FA156Accident · 4 fatalField investigationFinal reportBell 47J2 · Adjuntas, PRThe failure of the pilot-in-command to maintain adequate rotor RPM during a precautionary landing following the loss of engine oil. In addition, the pilot failed to insure that the engine contained adequate oil, and that the oil dip stick was secure prior to…Jul 29, 1992 · N8476E · DestroyedNTSB LAX92TL#12Accident · No injuriesClass 3Final reportCessna 185F · Termo, CAJul 29, 1992 · N22FG · Substantial damageNTSB FTW92LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Lubbock, TXThe pilot under instruction misjudged his distance and altitude during a simulated forced landing, and the CFI failed to take timely action to prevent the accident as a result of his alcoholic impairment of efficiency and judgement.Jul 29, 1992 · N5718R · Substantial damageNTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.Jul 29, 1992 · N22923 · Substantial damageNTSB CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.Jul 29, 1992 · N4573F · Substantial damageNTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…Jul 29, 1992 · N6503W · Substantial damageNTSB BFO92LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mount Vernon, OHThe pilot's failure to maintain airspeed which resulted in a stall.Jul 29, 1992 · N76MF · Substantial damageNTSB ANC92LA115Accident · 1 fatalLimited investigationFinal reportCessna 207 · Yakutat, AKThe pilot elected to fly an improper altitude. Contributing factors were the pilots attempt to fly VFR into IMC conditions, and the obscured weather.Jul 29, 1992 · N7ME · DestroyedNTSB ANC92LA114Accident · Minor injuriesLimited investigationFinal reportBeech 55-95B55B · Delta Junction, AKFuel starvation of both engines and the pilot's improper inflight planning/decision by not getting more fuel or cancelling the flight. Contributing factors to the accident was the pilot not following procedures/directives (the airplane flight manual) when he…Jul 29, 1992 · N7041M · Substantial damageNTSB MIA92LA155Accident · No injuriesLimited investigationFinal reportDewitt, Richard A. Kitfox · Vero Beach, FLFailure of the engine due to fuel contamination resulting in a forced landing in a grove at which time the aircraft struck trees.Jul 28, 1992 · N70629 · Substantial damageNTSB LAX92LA320Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Las Vegas, NVThe loss of directional control due to the students excessive use of the rudder controls, and, the instructors inadequate supervision of the flight.Jul 28, 1992 · N88212 · Substantial damageNTSB LAX92LA319Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Hayfork, CAThe failure of the main rotor drive shaft due to the improper installation by company maintenance personnel of an 'o' ring seal, which allowed the packing grease to escape and caused the over temperature failure of the drive shaft. A factor in the accident…Jul 28, 1992 · N89NW · Substantial damageNTSB LAX92LA318Accident · No injuriesLimited investigationFinal reportChapuis Spezio Sport · Wells, NVThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain directional control of the aircraft. A factor in the accident was the variable and gusty nature of the wind conditions at the airport.Jul 28, 1992 · N7715 · Substantial damageNTSB LAX92LA317Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Lovelock, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the presence of dust devils in the vicinity of the airport.Jul 28, 1992 · N6138Y · Substantial damageNTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.Jul 28, 1992 · N5063A · Substantial damageNTSB CHI92LA213Accident · No injuriesLimited investigationFinal reportBeech H35 · Baraboo, WIInadequate maintenance service and aircraft preflight by the pilot. A factor contributing to this accident was a partial failure of the brake system.Jul 28, 1992 · N7957D · Substantial damageNTSB BFO92LA118Accident · Minor injuriesLimited investigationFinal reportWaco AVN-8 · Hamilton, OHThe pilot misjudged distance and altitude which resulted in a landing overrun.Jul 28, 1992 · N19361 · Substantial damageNTSB ANC92LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka, AKThe loss of engine power and undetermined reasons.Jul 28, 1992 · N3266D · Substantial damageNTSB ANC92LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Wasilla, AKFailure of the engine crankshaft due to an oil passage hole being blocked. Contributing to the accident was the unsuitable terrain.Jul 28, 1992 · N9304B · Substantial damageNTSB ANC92LA112Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Cloudy Lake, AKThe pilot failed to enter an aerobatic maneuver with sufficient altitude to effect a recovery prior to ground impact.Jul 28, 1992 · N21375 · Substantial damageNTSB SEA92LA167Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Shelby, MTThe poor decision by the pilot to make an aerial application turn around manuever under power lines and his failure to maintain clearance from the power lines.Jul 27, 1992 · N4859 · DestroyedNTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.Jul 27, 1992 · N5639W · Substantial damageNTSB SEA92IA164Incident · 1 fatalIncident investigationFinal reportSmith Vari EZE · Terry, MTThe pilot in command's exceeding liftoff speed during a taxi test.Jul 27, 1992 · UNREG · DestroyedNTSB NYC92T#A01Accident · No injuriesClass 3Final reportMBB BO-105CBS · Brooklyn, NYJul 27, 1992 · N729RJ · Substantial damageNTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.Jul 27, 1992 · N1139S · Substantial damageNTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.Jul 27, 1992 · N731MR · Substantial damageNTSB SEA92LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spokane, WAThe premature landing flare by the recently certificated private pilot, and her failure to properly recover from the bounced landing. A factor relating to the accident was the gusty wind conditions.Jul 26, 1992 · N139CA · Substantial damageNTSB SEA92LA163Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Battleground, WAThe pilot in command's delayed decision to execute a go around. Factors contributing the accident were: a tailwind, trees, and the improper use of the carburetor heat and flaps by the pilot in command.Jul 26, 1992 · N26671 · DestroyedNTSB MIA92LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCFailure of the pilot-in-command to maintain adequate wingtip clearance with bushes off the side of the taxiway while taxiing to takeoff.Jul 26, 1992 · N25502 · Substantial damageNTSB LAX92LA342Accident · No injuriesLimited investigationFinal reportCessna 172 · Van Nuys, CAThe student pilot's improper use of the checklist to assure that the trim tab was in the proper position and failure to follow normal procedures and directives. Contributing to this accident was the pilot's lack of total experience, misreading of the trim…Jul 26, 1992 · N2781E · Substantial damageNTSB LAX92LA316Accident · No injuriesLimited investigationFinal reportCessna 177 · Turlock, CAThe pilots poor planning in not properly securing the aircraft with tiedowns, chocks or brakes prior to attempting to start the engine by hand propping.Jul 26, 1992 · N2279Y · Substantial damageNTSB LAX92LA314Accident · No injuriesLimited investigationFinal reportJames Schwarzman Avid Flyer Heavy · Truckee, CAFuel starvation due to the aircraft builder locating the fuel filter in an improper location during the construction of the airplane's fuel system.Jul 26, 1992 · N771AF · DestroyedNTSB FTW92FA189Accident · 1 fatalField investigationFinal reportBell 206B3 · Block 651aThe pilot's failure to maintain the proper glidepath during the approach which led to an excessive nose high attitude during the landing flare.Jul 26, 1992 · N2072B · DestroyedNTSB FTW92DPA01Accident · Serious injuriesFinal reportAir Tractor AT-301 · Dekalb, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jul 26, 1992 · N3167Y · DestroyedNTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…Jul 26, 1992 · N8262L · Substantial damageNTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.Jul 26, 1992 · N4389X · Substantial damageNTSB BFO92LA113Accident · No injuriesLimited investigationFinal reportStinson JR.SR. · Hanson, MAThe pilot inadequate compensation for wind which resulted in the loss of directional control.Jul 26, 1992 · N13462 · Substantial damageNTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.Jul 26, 1992 · N2521Y · Substantial damageNTSB ATL92LA145Accident · No injuriesLimited investigationFinal reportCessna 180B · Monroe, GAFailure of the pilot's seat assembly for an undetermined reason(s) which resulted in a loss of control during the takeoff roll.Jul 26, 1992 · N9581B · Substantial damageNTSB MIA92LA153Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 · Knoxville, TNThe pilot-in-command's failure to properly instruct the passenger on aircraft controls prior to takeoff, resulting in the passenger inadvertently releasing the tow cable as the glider was being towed through 150 feet.Jul 25, 1992 · N2135R · Substantial damage