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 SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.Jun 10, 1999 · N24MP · Substantial damageNTSB MIA99LA171Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lantana, FLThe poor in-flight planning by the pilot during the approach for a precautionary landing following a power interruption during the downwind leg, resulting in a go-around. A Contributing factor to the accident was the total loss of engine power during the…Jun 10, 1999 · N1578M · Substantial damageNTSB MIA99FA172Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cape Canaveral, FLThe pilot's VFR flight into Instrument meteorological conditions and his subsequent failure to maintain control of the aircraft resulting in overload and separation of both wings. Contributing factors were the pilot's failure to obtain a preflight and…Jun 10, 1999 · N56192 · DestroyedNTSB LAX99LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Weaverville, CAthe pilot's failure to follow prescribed procedures and directives for the particular airport.Jun 10, 1999 · N5577E · Substantial damageNTSB FTW99LA164Accident · No injuriesLimited investigationFinal reportCessna 172N · Spring, TXThe pilot's failure to maintain aircraft control during the takeoff roll. Factors were the crosswind condition and the pilot's lack of total experience in the make/model of aircraft.Jun 10, 1999 · N5103D · Substantial damageNTSB DEN99TA099Accident · No injuriesFinal reportCessna A185F · Farmington, NMThe pilot's inadequate visual lookout and failure to see and avoid a ground obstruction. Factors were the throttle linkage becoming disconnected due to an inadequate annual inspection by maintenance personnel, and a dirt berm.Jun 10, 1999 · N4211C · Substantial damageNTSB DEN99LA102Accident · No injuriesLimited investigationFinal reportSchweizer SGU-2-22E · Hobbs, NMPilot incapacitation (loss of consciousness) due to dehydration and hyperventilation. Factors were the turbulence and excessive workload (task overload) that induced anxiety/apprehension, and striking the sign and the pole.Jun 10, 1999 · N5823V · Substantial damageNTSB CHI99LA181Accident · Minor injuriesLimited investigationFinal reportRobbins Verieze · Odessa, MOThe pilot's misjudgment of altitude during landing.Jun 10, 1999 · N83HR · Substantial damageNTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.Jun 9, 1999 · N5309P · Substantial damageNTSB MIA99LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Auburn, ALThe pilot' failure to refuel the airplane prior to fuel exhaustion.Jun 9, 1999 · N983DB · DestroyedNTSB MIA99LA169Accident · No injuriesLimited investigationFinal reportCessna 140 · Woodstock, GAa total loss of engine power due to fuel starvation because of contaminated fuel, resulting in a forced landing and subsequent impact with a tree.Jun 9, 1999 · N76390 · Substantial damageNTSB LAX99LA212Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)intentional tampering/altering of a galley lift interlock microswitch by unknown persons.Jun 9, 1999 · N198UA · No damageNTSB FTW99LA162Accident · No injuriesLimited investigationFinal reportBell 412 · Eugene Is. 313The separation of a section of the tail rotor blade, and subsequent separation of the tail rotor system, as a result of fatigue cracking due to corrosion in the tail rotor blade spar.Jun 9, 1999 · N3893S · Substantial damageNTSB DCA99WA062Incident · No injuriesForeign investigationBoeing 757 · Tegucigalpa, HondurasJun 9, 1999 · N697AN · Minor damageNTSB DCA99WA061Accident · Minor injuriesForeign investigationBoeing 737-300 · Zhanjiang, ChinaJun 9, 1999 · B2525 · Substantial damageNTSB CHI99LA180Accident · No injuriesLimited investigationFinal reportCessna 182D · Zurich, KSthe pilot's inadequate preflight planning/preparation. A factor was fuel exhaustion.Jun 9, 1999 · N9169X · Substantial damageNTSB ANC99LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to maintain clearance from terrain. Factors associated with the accident are the confined/congested landing/takeoff area, and rocks/boulders in the takeoff area.Jun 9, 1999 · N265AH · Substantial damageNTSB ANC99LA071Accident · No injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe failure of the pilot to maintain directional control during the water landing.Jun 9, 1999 · N7560K · Substantial damageNTSB ANC99FA073Accident · 7 fatalField investigationFinal reportEurocopter AS-350BA · Juneau, AKThe pilot's continued VFR flight into adverse weather, spatial disorientation, and failure to maintain aircraft control. Factors associated with the accident were pressure by the company to continue flights in marginal weather, and the "flat" lighting leading…Jun 9, 1999 · N6099S · DestroyedNTSB SEA99LA082Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Southbend, WAThe complete loss of power, due to a failure of the compressor impeller disk. Factors include the low altitude of the helicopter at the time of the power loss, and the need to autorotate in a confined area.Jun 8, 1999 · N8306F · Substantial damageNTSB NYC99FA136Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS-350B · Ashcamp, KYThe pilot's inadequate visual look out which resulted in an in-flight collision with wires.Jun 8, 1999 · N35AG · DestroyedNTSB MIA99FA168Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLThe pilot's decision takeoff with condensation on the cockpit windows which restricted visibility, his improper use of aileron control, improper compensation for winds during takeoff, and his failure to maintain directional control during takeoff, resulting…Jun 8, 1999 · N440AB · Substantial damageNTSB FTW99LA161Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Dewitt, ARThe pilot's inadvertent flight into adverse weather, which resulted in a loss of aircraft control. A factor was the downdraft weather condition.Jun 8, 1999 · N52401 · Substantial damageNTSB CHI99LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Traer, IAThe pilot's not maintaining proper runway alignment during the aborted takeoff, and the airport personnel not maintaining the runway. Factors were rough terrain and a dirt bank.Jun 8, 1999 · N4525R · Substantial damageNTSB CHI99LA176Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Demotte, INThe pilot's misjudging distance/speed resulting in an overrun. A contributing factor was the wet condition of the turf runway.Jun 8, 1999 · N3791Z · Substantial damageNTSB CHI99FA177Accident · 2 fatalField investigationFinal reportCessna 340A · Phillipsburg, KSthe pilot not maintaining flying speed. Factors to the accident were the fuel transfer problem of unknown origin.Jun 8, 1999 · N1372G · DestroyedNTSB MIA99LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150M · St. Augustine, FLThe student pilot's inadequate compensation for the crosswind condition. A factor associated with the accident was the crosswind.Jun 7, 1999 · N704KK · Substantial damageNTSB LAX99LA253Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The removal of the tail rotor blade abrasion strips by the use of an unapproved method by the maintenance personnel which resulted in the imbalance of the tail rotor blade assembly and subsequent separation of the 90-degree gear box; the pilot/mechanic's…Jun 7, 1999 · N4278M · DestroyedNTSB LAX99LA210Accident · No injuriesLimited investigationFinal reportBellanca BL-14-13 · Taft, CAThe pilot's inability to maintain control of the aircraft due to the aileron control cables being crossed and reversed. The pilot's lack of a thorough pre-flight inspection and the pilot not referencing a manual during the repairs on the aircraft is also…Jun 7, 1999 · N74476 · DestroyedNTSB LAX99FA218Accident · No injuriesField investigationFinal reportBoeing 747-4F6B · Los Angeles, CAAirport management's failure to ensure that its current operating procedure, which required the arriving airplane to power into the terminal gate, was being used. Also causal was (1) the ground service company's utilization of an outdated arrival procedure…Jun 7, 1999 · N751PR · 2 aircraft · Minor damageNTSB CHI99LA178Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Salem, MOthe engine quit due to water contamination of the fuel and the pilot's inadequate preflight.Jun 7, 1999 · N9071T · Substantial damageNTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.Jun 7, 1999 · N246MA · DestroyedNTSB SEA99LA081Accident · 1 fatalLimited investigationFinal reportD. Wayne Smith Wayncraft 14 · Libby, MTCollision with terrain for undetermined reasons.Jun 6, 1999 · N58WS · Substantial damageNTSB MIA99LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Rolling Fork, MSImproper torqueing of the connecting rod bolts which resulted in the bolts being loose and rubbing in the dowel area which resulted in fatigue emanation and cracking and separation of the number 3 connecting rod after bolt failure.Jun 6, 1999 · N9267X · Substantial damageNTSB MIA99LA165Accident · Serious injuriesLimited investigationFinal reportSchmidt Airshark II · Peachtree City, GAThe failure of the pilot to follow appropriate wake turbulence avoidance procedures, and wait an adequate amount of time prior to taking off behind a corporate jet.Jun 6, 1999 · N911FM · Substantial damageNTSB MIA99LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Timmonsville, SCThe loss of engine power due to the improper installation and in-flight separation of an engine cylinder.Jun 6, 1999 · N1982Q · Substantial damageNTSB LAX99LA209Accident · 1 fatalLimited investigationFinal reportBlanco SEA Hawker · Yucca Valley, CAA loss of control in flight for undetermined reasons that resulted in an in flight collision with terrain. A factor was turbulent weather conditions in mountainous/hilly terrain.Jun 6, 1999 · N2485 · DestroyedNTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.Jun 6, 1999 · N3191V · DestroyedNTSB DEN99LA098Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Belen, NMEncounter with soft unsuitable terrain when the aircraft departed the side of the runway during landing roll due to binding in the right main landing gear wheel assembly. A factor was the binding in the main landing gear.Jun 6, 1999 · N99DA · Substantial damageNTSB DEN99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Glenwood Sprngs, COThe pilot-in-command's failure to maintain directional control. A related factor was the gusty quartering tailwind.Jun 6, 1999 · N897SP · Substantial damageNTSB DEN99LA096Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cheyenne, WYThe pilot's inadequate flight planning, and lack of suitable terrain for the forced landing. Factor's were the pilot's inadequate aircraft preflight, and the subsequent engine power loss due to fuel exhaustion.Jun 6, 1999 · N2637V · Substantial damageNTSB DEN99LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Salt Lake City, UTFailure of the nose landing gear scissors bolt for undetermined reasons.Jun 6, 1999 · N2276G · Substantial damageNTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.Jun 6, 1999 · N3024U · Substantial damageNTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…Jun 5, 1999 · N3508B · Substantial damageNTSB MIA99LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chapel Hill, NCThe failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.Jun 5, 1999 · N68762 · DestroyedNTSB MIA99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jackson, MSThe loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.Jun 5, 1999 · N78HR · Substantial damageNTSB LAX99LA219Accident · No injuriesLimited investigationFinal reportBeech A-36 · Van Nuys, CAThe failure of the pilot to verify that the alternator was activated after engine start, subsequently resulting in a total electrical failure; and his inadequate emergency procedures for manual extension of the landing gear following the electrical failure.Jun 5, 1999 · N126GL · Substantial damageNTSB LAX99LA211Accident · 1 fatalLimited investigationFinal reportCessna 150G · Rimrock, AZThe pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…Jun 5, 1999 · N2675J · Substantial damageNTSB IAD99WA072Accident · No injuriesForeign investigationMooney M20 · FranceJun 5, 1999 · FGJGNNTSB IAD99LA049Accident · No injuriesLimited investigationFinal reportKucki Pitts S-1S · Mitchellville, MDwas the loss of braking action on the left side due to a broken brake caliper.Jun 5, 1999 · N86RK · Substantial damage