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 DCA99WA050Accident · No injuriesForeign investigationBoeing 737-228 · Biarritz, FranceNTSB CHI99FA101Accident · 1 fatalField investigationFinal reportMooney M20F · Cabool, MOThe pilot not maintaining an appropriate airspeed during the turn from base to final resulting in a stall.NTSB ANC99LA030Accident · Minor injuriesLimited investigationFinal reportInterstate S-1B1 · Anchorage, AKFuel starvation resulting from the pilot not understanding the fuel system procedures, and selecting the improper fuel selector position.NTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.NTSB NYC99LA069Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Atlantic City, NJUnanticipated in-flight turbulence.NTSB MIA99LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)a loss of engine power for an undetermined reason, resulting in a forced landing in water, and subsequent sinking of the airplane.NTSB MIA99LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-601P · Statesville, NCthe pilot's failure to attain the proper touchdown point on the runway. Factors in this accident were excessive approach speed, rain, and a wet runway.NTSB SEA99LA038Accident · 1 fatalLimited investigationFinal reportSikorsky S-64E · Shelton, WAThe failure of the victim to follow the procedure that required him to make sure that all choker lines had separated from the helicopter's release mechanism prior to entering the landing (collection area).NTSB IAD99WA033Accident · No injuriesForeign investigationRobinson R-44 · Sines, PortugalNTSB CHI99IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Salina, KSThe ARTCC personnel failed to maintain radio communications with both airplanes and failed to maintain IFR separation standards. Factors relating to the incident were the FAA does not require cargo airplanes to be equipped with TCAS and neither airplane was…NTSB MIA99LA093Accident · No injuriesLimited investigationFinal reportScott A. George Jr. Fisher Celebrity · Simpsonville, SCThe unsuitable terrain encountered during the forced landing. Contributing to the accident was the total loss of engine power due to the failure of a plastic 90-degree fitting at the inlet fitting of the carburetor.NTSB FTW99LA088Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe total loss of engine power on takeoff resulting from the failure of an incorrect throttle control cable clamp, which was installed by an unknown person. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COThe pilot's failure to maintain directional control and inadvertently allowing the airplane to ground loop. Factors were gusty crosswind conditions, pertinent crosswind information not made available by the manufacturer, and FAA's inadequate certification and…NTSB DCA99WA042Accident · No injuriesForeign investigationLockheed L-188 · Shannon, IrelandNTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.NTSB SEA99FA037Accident · No injuriesField investigationFinal reportHiller UH-12E · Yellow Pine, IDAltitude deviation during aerial taxi for undetermined reasons.NTSB NYC99LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Wolfeboro, NHThe pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.NTSB MIA99LA096Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stuart, FLThe inadequate touchdown resulting in a hard landing on the nose landing gear and subsequent structural damage.NTSB LAX99LA113Accident · 1 fatalLimited investigationFinal reportCessna P210N · Pacific Ocean (Pacific Ocean)A loss of engine oil pressure and ensuing loss of engine power for undetermined reasons.NTSB FTW99LA087Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor was the crosswind.NTSB FTW99LA086Accident · 1 fatalLimited investigationFinal reportKeil Jaeger D-IX · Santa Fe, TXThe separation of the right upper aileron for an undetermined reason.NTSB DEN99LA044Accident · No injuriesLimited investigationFinal reportParsons Kitfox II · Colorado Spgs, COThe airplane's encounter with a dust devil during landing.NTSB DEN99LA043Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Leadville, COThe pilot's in-flight decision to turn into rising terrain, and his decision to fly into and out of the airport in a heavy weight condition after the local flight instructor/FAA accident prevention counselor recommended that he should not. Factors were the…NTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.NTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…NTSB MIA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Franklin, NCThe failure of the pilot to maintain directional control of the airplane on final approach resulting in the in-flight collision with trees and the ground.NTSB MIA99FA095Accident · 2 fatalField investigationFinal reportBeech AT11/18 · Tampa, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to allow for recovery.NTSB LAX99LA112Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · San Jose, CAThe loss of aircraft control due to the pilot's sudden application of collective combined with excessive cyclic inputs.NTSB IAD99LA031Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Sanford, METhe pilot mismanaged his fuel supply which led to fuel starvation and subsequent loss of engine power.NTSB DEN99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-23C-250 · Lamar, COThe pilot's improper use of the airplane's fuel tank selector switches. Factors were the fuel starvation to both engines, the pilot's lack of sleep, and the soft terrain.NTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.NTSB LAX99LA111Accident · Minor injuriesLimited investigationFinal reportCooper Vans RV-6 · Vacaville, CAThe failure of the engine assembler to apply the proper torque on the connecting rods bolts, which led to fatigue cracking and ultimately fracture of the rod bolts.NTSB LAX99LA110Accident · No injuriesLimited investigationFinal reportHelio Jergins H 800 · Prescott, AZThe malfunction of the propeller for undetermined reasons at an altitude too low for the pilot to take effective remedial action.NTSB LAX99LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Death Valley, CAThe pilot's use of an excessive approach reference speed and his misjudged distance/speed relationship to the runway, which resulted in a landing overrun. The pilot's failure to execute a timely go-around was also causal.NTSB IAD99RA032Accident · 2 fatalForeign investigationBell 407 · Belo Horizonte, BrazilNTSB FTW99LA085Accident · Minor injuriesLimited investigationFinal reportEurocopter Colibri EC120B · Springtown, TXThe improper touchdown executed by the pilot. Factors were the tail wind condition, and the manufacturer's inadequate design of the P3 pipe supports, which resulted in a fatigue fracture of the P3 pipe.NTSB MIA99LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot's failure to maintain directional control during the landing roll. A related factor was the pilot's diverted attention.NTSB MIA99LA091Accident · No injuriesLimited investigationFinal reportMooney M20J · St. Cloud, FLThe improper installation of the propeller by maintenance personnel resulting in fretting of the face of the propeller hub and fatigue failure of the No. 1 propeller blade. Also, the unsuitable terrain encountered during the descent for the forced landing.NTSB ANC99TA029Accident · Minor injuriesFinal reportBell 206L-1 · Barrow, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and the snow-covered terrain.NTSB NYC99LA064Accident · No injuriesLimited investigationFinal reportBoeing 757 · Covington, KYA flock birds were ingested into both engines, resulting in substantial damage to the engines.NTSB DEN99LA042Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Telluride, COA loss of engine power due to the ingestion of air in the fuel line, the pilot's failure to purge the fuel line of unwanted air prior to flight as outlined in the Airplane Flight Manual, and inadequate altitude in which to glide to the airport.NTSB CHI99LA095Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOthe pilot's improper positioning of the fuel selector. Factors to the accident were the transmission wires, the building, and the flood levy wall.NTSB NYC99LA065Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Bristol, CTThe partial loss of power due to the failure of a fatigued connecting rod bolt.NTSB NYC99LA063Accident · 1 fatalLimited investigationFinal reportPiper PA 32R-301 · Dulles, VAThe FBO employee's diverted attention, resulting in an inadvertent encounter with a rotating propeller.NTSB MIA99LA090Accident · No injuriesLimited investigationFinal reportCessna 172P · Pelion, SCThe pilot's loss of directional control during landing roll as a result of improper recovery from a bounced landing and the subsequent excursion from the runway, collision with the adjacent terrain, and collapse of the nose landing gear.NTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…NTSB LAX99LA108Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Glenn, CAAn inflight loss of control for undetermined reasons.NTSB CHI99LA097Accident · No injuriesLimited investigationFinal reportCessna 182E · East Troy, WIthe collapse of the right main landing gear from a preexisting fatigue crack.NTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.NTSB SEA99LA036Accident · No injuriesLimited investigationFinal reportPiper J-5A · Rexburg, IDThe pilot's failure to maintain clearance from power lines.