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 DCA99WA050Accident · No injuriesForeign investigationBoeing 737-228 · Biarritz, FranceMar 4, 1999 · FGBYA · Substantial damageNTSB 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.Mar 4, 1999 · N9381M · DestroyedNTSB 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.Mar 4, 1999 · N48027 · Substantial damageNTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.Mar 3, 1999 · N756AV · Substantial damageNTSB NYC99LA069Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Atlantic City, NJUnanticipated in-flight turbulence.Mar 3, 1999 · N343BE · No damageNTSB 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.Mar 3, 1999 · N4802S · DestroyedNTSB 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.Mar 3, 1999 · N727MB · Substantial damageNTSB 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).Mar 2, 1999 · N194AC · No damageNTSB IAD99WA033Accident · No injuriesForeign investigationRobinson R-44 · Sines, PortugalMar 2, 1999 · CS-HEI · Substantial damageNTSB 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…Mar 2, 1999 · N40061 · 2 aircraft · No damageNTSB 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.Mar 1, 1999 · N1122V · Substantial damageNTSB 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.Mar 1, 1999 · N92350 · Substantial damageNTSB 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…Mar 1, 1999 · N9823X · Substantial damageNTSB DCA99WA042Accident · No injuriesForeign investigationLockheed L-188 · Shannon, IrelandMar 1, 1999 · N285F · Substantial damageNTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.Mar 1, 1999 · N394GL · DestroyedNTSB SEA99FA037Accident · No injuriesField investigationFinal reportHiller UH-12E · Yellow Pine, IDAltitude deviation during aerial taxi for undetermined reasons.Feb 28, 1999 · N2239 · Substantial damageNTSB 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.Feb 28, 1999 · N8790N · Substantial damageNTSB 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.Feb 28, 1999 · N2313Z · Substantial damageNTSB 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.Feb 28, 1999 · HSKCC · DestroyedNTSB 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.Feb 28, 1999 · N11760 · Substantial damageNTSB FTW99LA086Accident · 1 fatalLimited investigationFinal reportKeil Jaeger D-IX · Santa Fe, TXThe separation of the right upper aileron for an undetermined reason.Feb 28, 1999 · N257JK · DestroyedNTSB DEN99LA044Accident · No injuriesLimited investigationFinal reportParsons Kitfox II · Colorado Spgs, COThe airplane's encounter with a dust devil during landing.Feb 28, 1999 · N740GP · Substantial damageNTSB 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…Feb 28, 1999 · N977MC · Substantial damageNTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.Feb 27, 1999 · N8923J · Substantial damageNTSB 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…Feb 27, 1999 · N25856 · DestroyedNTSB 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.Feb 27, 1999 · N460JM · Substantial damageNTSB 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.Feb 27, 1999 · N65860 · DestroyedNTSB 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.Feb 27, 1999 · N5700C · Substantial damageNTSB 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.Feb 27, 1999 · N4524Y · Substantial damageNTSB 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.Feb 27, 1999 · N6574Y · Substantial damageNTSB 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.Feb 26, 1999 · N737MJ · Substantial damageNTSB 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.Feb 26, 1999 · N36VR · Substantial damageNTSB 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.Feb 26, 1999 · N666X · Substantial damageNTSB 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.Feb 26, 1999 · N99269 · Substantial damageNTSB IAD99RA032Accident · 2 fatalForeign investigationBell 407 · Belo Horizonte, BrazilFeb 26, 1999 · PT-YVINTSB 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.Feb 26, 1999 · N122TH · Substantial damageNTSB 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.Feb 25, 1999 · N49407 · Substantial damageNTSB 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.Feb 25, 1999 · N4671H · Substantial damageNTSB 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.Feb 24, 1999 · N785SR · Substantial damageNTSB NYC99LA064Accident · No injuriesLimited investigationFinal reportBoeing 757 · Covington, KYA flock birds were ingested into both engines, resulting in substantial damage to the engines.Feb 22, 1999 · N682DA · Substantial damageNTSB 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.Feb 22, 1999 · N345MD · DestroyedNTSB 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.Feb 22, 1999 · N6014F · Substantial damageNTSB NYC99LA065Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Bristol, CTThe partial loss of power due to the failure of a fatigued connecting rod bolt.Feb 21, 1999 · N6191M · Substantial damageNTSB NYC99LA063Accident · 1 fatalLimited investigationFinal reportPiper PA 32R-301 · Dulles, VAThe FBO employee's diverted attention, resulting in an inadvertent encounter with a rotating propeller.Feb 21, 1999 · N3559U · No damageNTSB 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.Feb 21, 1999 · N65770 · Substantial damageNTSB 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…Feb 21, 1999 · N8309P · Substantial damageNTSB LAX99LA108Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Glenn, CAAn inflight loss of control for undetermined reasons.Feb 21, 1999 · N6258Z · DestroyedNTSB CHI99LA097Accident · No injuriesLimited investigationFinal reportCessna 182E · East Troy, WIthe collapse of the right main landing gear from a preexisting fatigue crack.Feb 21, 1999 · N3177Y · Substantial damageNTSB CHI99FA094Accident · 2 fatalField investigationFinal reportCessna 172C · Grenola, KSloss of control in flight due to incapacitation.Feb 21, 1999 · N1831Y · DestroyedNTSB SEA99LA036Accident · No injuriesLimited investigationFinal reportPiper J-5A · Rexburg, IDThe pilot's failure to maintain clearance from power lines.Feb 20, 1999 · N28123 · Substantial damage