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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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.NTSB LAX98LA225Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Salinas, CAThe failure of the pilot to maintain clearance with the telephone lines.NTSB 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.NTSB 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.NTSB 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…NTSB SEA98WA127Accident · 2 fatalForeign investigationCessna U-206F · Tofino, CanadaNTSB SEA98LA123Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Arlington, WAThe pilot's inadequate compensation for the wind conditions. Gusting winds were a factor.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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 pilotNTSB ATL98LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe student pilot's failure to maintain directional control of the airplane during takeoff.NTSB 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.NTSB 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.NTSB LAX98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Chico, CALoss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB FTW98LA293Accident · No injuriesLimited investigationFinal reportCessna T188C · Weslaco, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB 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.NTSB DCA98WA063Incident · No injuriesForeign investigationDouglas MD-11 · Palma Mallorca, SpainNTSB ATL98LA097Accident · Minor injuriesLimited investigationFinal reportBenson B-8M · Placida, FLExcessive taxi speed. A related factor was the wind gusts.NTSB ANC98IA096Incident · No injuriesIncident investigationFinal reportCessna 185 · Homer, AKThe failure of the right main landing gear leg due to corrosion pitting and fatigue.NTSB 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.NTSB 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.NTSB NYC98LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7GCG · Neavitt, MDThe pilot's failure to maintain control of the airplane.NTSB IAD98LA076Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Somerset, KYthe pilot's failure to follow procedures to hand-prop the airplane.NTSB 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.NTSB 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.NTSB 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.NTSB CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.NTSB CHI98LA237Accident · No injuriesLimited investigationFinal reportCessna 172M · Chesterfield, MOthe pilot's not obtaining and maintaining directional control. A factor was wet terrain (grass).NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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).NTSB SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.NTSB 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.NTSB 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.NTSB FTW98LA296Accident · No injuriesLimited investigationFinal reportGrumman G164A · Stratton, COA power loss for reasons undetermined. A factor was the muddy corn field.NTSB 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.NTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.NTSB CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.NTSB CHI98FAMS1Accident · 2 fatalMissing aircraftFinal reportAero Vodochody Aero. Works L-39C · Traverse City, MIUndetermined.NTSB 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.NTSB SEA98LA118Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Hamilton, MTPartial failure of the anti-skid brake system due to contamination.NTSB 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.