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 MIA98IA193Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Birmingham, ALThe improper electronic control unit software logic that permitted the electronic control unit to lock on a failed hydromechanical resolver, which failed due to damage to a wire that was incurred during the manufacturing process, resulting in an uncommanded…Jul 7, 1998 · N701GS · Minor damageNTSB LAX98LA231Accident · No injuriesLimited investigationFinal reportCessna 182RG · Cameron Park, CAThe pilot's decision to initiate a turn to exit the runway at an excessive rate of speed.Jul 7, 1998 · N4825R · Substantial damageNTSB LAX98LA225Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Salinas, CAThe failure of the pilot to maintain clearance with the telephone lines.Jul 7, 1998 · N7914S · DestroyedNTSB FTW98LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Beaumont, TXThe pilot's failure to maintain control of the airplane while attempting to return to the airport. Factors were the open baggage compartment door and the pilot's diverted attention to the open door.Jul 7, 1998 · N6898Y · Substantial damageNTSB CHI98LA241Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fort Ransom, NDA loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.Jul 7, 1998 · N4232X · Substantial damageNTSB ANC98FA091Accident · 2 fatalField investigationFinal reportSwearingen SA-26AT · St. George, AKThe pilot-in-command's failure to adequately monitor the instrument approach and the co-pilot's failure to intercept and maintain the proper NDB bearing on the approach. Contributing factors were the pilot-in-command's obstructed view of the NDB indicator and…Jul 7, 1998 · N501FS · DestroyedNTSB SEA98WA127Accident · 2 fatalForeign investigationCessna U-206F · Tofino, CanadaJul 6, 1998 · N9516G · DestroyedNTSB SEA98LA123Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Arlington, WAThe pilot's inadequate compensation for the wind conditions. Gusting winds were a factor.Jul 6, 1998 · N91380 · Substantial damageNTSB NYC98LA139Accident · No injuriesLimited investigationFinal reportRoss RV6A · Hunter, NYthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane. The gusty/variable wind condition was a related factor.Jul 6, 1998 · N67KH · Substantial damageNTSB MIA98LA188Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Okeechobee, FLthe pilot's improper planning/decision, by failing to ensure the aircraft contained adequate fuel to complete the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Obstructions (trees and guardrail) in the emergency landing…Jul 6, 1998 · N10349 · Substantial damageNTSB FTW98LA311Accident · No injuriesLimited investigationFinal reportCessna 172N · Yoakum, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.Jul 6, 1998 · N5103D · Substantial damageNTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.Jul 6, 1998 · N5554D · Substantial damageNTSB CHI98LA240Accident · No injuriesLimited investigationFinal reportCessna T188C · Austin, MNthe improper maintenance by other maintenance personnel. Factors were the throttle control not safetied, the crops, and unsuitable terrain encountered by the pilotJul 6, 1998 · N9957J · Substantial damageNTSB ATL98LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe student pilot's failure to maintain directional control of the airplane during takeoff.Jul 6, 1998 · N739ZA · Substantial damageNTSB LAX98LA224Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Livermore, CAThe pilot's failure to maintain adequate clearance from the trees. A related factor was the mountainous terrain.Jul 5, 1998 · N23670 · Substantial damageNTSB LAX98LA223Accident · 1 fatalLimited investigationFinal reportMorane-Saulnier MS 880B · Trinity Center, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering in a mountainous area at low altitude, which resulted in an inadvertent stall/spin.Jul 5, 1998 · N55BF · DestroyedNTSB LAX98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Chico, CALoss of engine power for undetermined reasons.Jul 5, 1998 · N592SP · Substantial damageNTSB LAX98LA221Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Llano, CAThe failure of the pilot to attach the aileron quick disconnect fitting during assembly of the glider and his inadequate preflight inspection.Jul 5, 1998 · N6686 · DestroyedNTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.Jul 5, 1998 · N103GG · Substantial damageNTSB FTW98LA298Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Longmont, COThe partial failure of the tail wheel steering system due to improper maintenance and the subsequent inadvertent ground loop during the landing sequence. Factors were the airport taxiway sign and the subsequent failure of the left main landing gear.Jul 5, 1998 · N8399H · Substantial damageNTSB FTW98LA293Accident · No injuriesLimited investigationFinal reportCessna T188C · Weslaco, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.Jul 5, 1998 · N3963J · Substantial damageNTSB FTW98FA299Accident · 1 fatalField investigationFinal reportGrumman American AA-1A · Larkspur, COThe pilot inadvertently stalling the airplane and entering an unrecoverable spin. A factor was clear air turbulence.Jul 5, 1998 · N9453L · DestroyedNTSB DCA98WA063Incident · No injuriesForeign investigationDouglas MD-11 · Palma Mallorca, SpainJul 5, 1998 · DAERB · No damageNTSB ATL98LA097Accident · Minor injuriesLimited investigationFinal reportBenson B-8M · Placida, FLExcessive taxi speed. A related factor was the wind gusts.Jul 5, 1998 · N2289V · Substantial damageNTSB ANC98IA096Incident · No injuriesIncident investigationFinal reportCessna 185 · Homer, AKThe failure of the right main landing gear leg due to corrosion pitting and fatigue.Jul 5, 1998 · N3347L · Minor damageNTSB SEA98LA120Accident · No injuriesLimited investigationFinal reportBeech D35 · Driggs, IDExcessive pressure in the fuel control unit. A foreign material/substance found on the fuel system screens was a factor.Jul 4, 1998 · N3469B · Substantial damageNTSB SEA98LA119Accident · No injuriesLimited investigationFinal reportCessna 170A · Renton, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Failure to jettison the external load and downdrafts were factors.Jul 4, 1998 · N1296D · Substantial damageNTSB NYC98LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7GCG · Neavitt, MDThe pilot's failure to maintain control of the airplane.Jul 4, 1998 · N9985Y · Substantial damageNTSB IAD98LA076Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Somerset, KYthe pilot's failure to follow procedures to hand-prop the airplane.Jul 4, 1998 · N12187 · Substantial damageNTSB FTW98LA341Accident · No injuriesLimited investigationFinal reportCessna T210K · Del Norte, COThe pilot's improper touchdown point for landing. Factors were the high density altitude, the downhill sloping runway, and the ditch off the end of the runway.Jul 4, 1998 · N8132G · Substantial damageNTSB FTW98LA302Accident · No injuriesLimited investigationFinal reportKeith Team Mini MAX 1600R · Santa Fe, TXThe loss of engine power as result of the failure of the cooling fan belt. A factor was the lack of suitable terrain for the pilot to execute the forced landing.Jul 4, 1998 · N106BK · Substantial damageNTSB CHI98LA242Accident · No injuriesLimited investigationFinal reportBrunnemer HMB-2 · Greenwood, INA loss of engine power due to a fractured ignition coil. A factor to the accident was the soft terrain.Jul 4, 1998 · N9129F · Substantial damageNTSB CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.Jul 4, 1998 · N5829G · Substantial damageNTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).Jul 4, 1998 · N2XC · Substantial damageNTSB ATL98LA100Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-4-250 · Wise, NCThe pilot's improper turn during the takeoff that resulted in dragging the sponson. A factor was the rough water caused by the boat wake.Jul 4, 1998 · N1401P · Substantial damageNTSB ATL98LA093Accident · Serious injuriesLimited investigationFinal reportLane Progressive Aerodyne Searey · Windermere, FLThe inadequate design of the landing gear switch by the builder which allowed an inadvertent activation of the landing gear switch, leading to a gear extension during a water landing.Jul 4, 1998 · N26RL · Substantial damageNTSB ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.Jul 4, 1998 · N7247E · Substantial damageNTSB ATL98LA091Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe loss of engine power for undetermined reasons which led to a forced landing and nose over. A factor affecting the severity of the damage was the soft terrain.Jul 4, 1998 · N42760 · Substantial damageNTSB SEA98LA155Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Douglas, WAThe pilot's failure to maintain clearance from objects on the ground. Factors include misjudgment of weather conditions (unfavorable winds).Jul 3, 1998 · N707NL · Substantial damageNTSB SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.Jul 3, 1998 · N92519 · Substantial damageNTSB NYC98LA140Accident · Serious injuriesLimited investigationFinal reportFithian Falcon XP · Mahopac, NYThe failure of the engine crankshaft, which resulted in a loss of engine power, and the pilot's improper decision to conduct flight over terrain unsuitable for the completion of a forced landing.Jul 3, 1998 · UNREG · Substantial damageNTSB LAX98LA220Accident · Serious injuriesLimited investigationFinal reportBushby Mustang II · Livermore, CAAn inadequate inspection of the flight control system during the condition inspection by the check pilot/mechanic.Jul 3, 1998 · N7LP · Substantial damageNTSB FTW98LA296Accident · No injuriesLimited investigationFinal reportGrumman G164A · Stratton, COA power loss for reasons undetermined. A factor was the muddy corn field.Jul 3, 1998 · N36RA · Substantial damageNTSB FTW98LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Watkins, COThe pilot's inadequate evaluation of the weather which resulted in an encounter with a microburst. Contributing was the airplane's climb capability exceeded by the microburst, and rising terrain.Jul 3, 1998 · N7780U · DestroyedNTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.Jul 3, 1998 · N1656J · Substantial damageNTSB CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.Jul 3, 1998 · N7301Y · Substantial damageNTSB CHI98FAMS1Accident · 2 fatalMissing aircraftFinal reportAero Vodochody Aero. Works L-39C · Traverse City, MIUndetermined.Jul 3, 1998 · N7868M · DestroyedNTSB ATL98LA090Accident · Minor injuriesLimited investigationFinal reportMbb Phoebus C · Perry, SCThe pilot's loss of control during takeoff, leading to an in-flight collision with the ground. A factor was the pilot's lack of recent experience in a high performance glider.Jul 3, 1998 · N2157 · Substantial damageNTSB SEA98LA118Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Hamilton, MTPartial failure of the anti-skid brake system due to contamination.Jul 2, 1998 · N900CS · Substantial damageNTSB SEA98LA116Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Langley, WAClearance from an object was not maintained. The pilot's lack of recent experience in the type of aircraft, improper use of carburetor heat and exceeding the gross weight of the airplane were factors.Jul 2, 1998 · N8153V · Substantial damage