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 MIA94LA209Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Fort Pierce, FLThe pilot's inadequate compensation for wind conditions and premature lift-off. The crosswind was a factor.NTSB LAX94LA362Accident · No injuriesLimited investigationFinal reportBeech B19 · Big Bear City, CAthe failure and separation of the right main landing gear wheel assembly due to a preexisting and undetected crack.NTSB LAX94LA359Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Corona, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion and the rough terrain were factors in this accident.NTSB CHI94LA322Accident · No injuriesLimited investigationFinal reportCessna 172N · Boone, IAthe failure of both pilots to adequately monitor radio communications during an exceptionally busy period. Factors related to the accident were the high vegetation and the failure of airport personnel to recognize and correct a hazardous situation.NTSB CHI94LA320Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Stephen, MNimproper rigging of the parking brake control cable resulting in inadvertent application of the left wheel brake.NTSB ATL94LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Lancaster, SCThe pilot's delay in taking remedial action when the engine failed to develop takeoff RPM. A factor was conditions favorable for the formation of carburetor ice.NTSB SEA94LA244Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Bozeman, MTThe student pilot's improper compensation for wind. The crosswind was a factor.NTSB NYC94LA177Accident · No injuriesLimited investigationFinal reportCessna 195 B · Richmond, VAThe pilot's failure to maintain directional control which resulted in a ground loop. Contributing factors are excessive airspeed, fatigue, and improper recovery from a bounced landing.NTSB NYC94LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · North Anson, MEthe inadequately installed cylinder mounting stud nuts, by the engine overhaul facility, which resulted in the separation of the number two cylinder and the subsequent forced landing.NTSB NYC94LA173Accident · No injuriesLimited investigationFinal reportSchleicher ASW15B · Dansville, NYThe pilot allowed the speed of the glider to get to low on final approach which resulted in a rapid descent, subsequent undershoot of the runway, and impact with a tree. A factor in this accident was a downdraft condition.NTSB NYC94LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lockwood, WVAn electrical ground short of the ignition wires which resulted in a loss of engine power.NTSB MIA94LA208Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Deland, FLThe pilot in command's failure to maintain ground clearance while maneuvering over the runway threshold resulting in the left wing contacting the ground.NTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB CHI94LA324Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrenton, MOthe pilot's failure to use the proper procedure for an aborted takeoff. Factors associated with the accident were the trees, the pilot's poor preflight/preparation, and the pilot's selection of unsuitable terrain for landing.NTSB CHI94LA319Accident · Serious injuriesLimited investigationFinal reportSnider CP328 Super Emeraude · Painton, MOin flight delamination and subsequent failure of the hand carved wooden propeller.NTSB ANC94LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe failure of the pilot to compensate for a tailwind and maintain directional control of the airplane. A tailwind was a factor in the accident.NTSB ANC94LA133Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairbanks, AKUndetermined.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94FA237Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Dixon, MTThe pilot in command's allowing the aircraft airspeed to decrease below the stall speed.NTSB FTW94LA296Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Grand Junction, COImproper remedial action in correcting for excessive speed and sink rate during an autorotation. Factors were: high density altitude, excessive airspeed and sink rate.NTSB FTW94LA294Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Englewood, COThe pilot's inadvertent groundloop of the airplane.NTSB CHI94LA323Accident · No injuriesLimited investigationFinal reportBeech D18S · Mt Pleasant, MIthe improper fuel selector position by the pilot-in-command which resulted in fuel starvation. A factor was rough/uneven terrain.NTSB CHI94LA318Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · West Branch, MIthe pilot's improper preflight planning in estimating the takeoff distance. The tall, wet grass on the runway was a factor.NTSB SEA94LA236Accident · No injuriesLimited investigationFinal reportCessna 182 · Circle, MTThe failure of the pilot-in-command (CFI) to perform an adequate preflight inspection of the airplane, including the proper securing of the fuel cap. The pilot's failure to divert to the nearest airport after recognizing excessive fuel consumption was a…NTSB LAX94LA357Accident · No injuriesLimited investigationFinal reportCanadair CL600 · Burbank, CAthe ground crew's failure to follow company procedures. The failure of the operator to provide headsets to communicate with the flightcrew and the poor lighting conditions were factors in this accident.NTSB LAX94LA356Accident · No injuriesLimited investigationFinal reportHawker Siddeley HS-125-700A · Reno, NVthe rupture of fuel and hydraulic lines and the fuselage fuel tank, by tire pieces during the tire blow-out sequence.NTSB FTW94FA293Accident · Minor injuriesField investigationFinal reportEurocopter AS-350-B2 · Cascade, COA power loss due to contaminated fuel from an unknown source that clogged the fuel filter and internally damaged the fuel control unit. A factor was unsuitable terrain for a forced landing.NTSB DCA94MA076Accident · 132 fatalClass 1 · MajorFinal reportBoeing B-737-300 · Aliquippa, PAA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB CHI94LA326Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brookfield, WIthe commercial pilot's poor planning/decision making. A related factor is the wet, grass runway selected for landing.NTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.NTSB CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB CHI94DER03Accident · Serious injuriesFinal reportSmart CP 301 · Remer, MNthe failure of the alternator/electrical system, and subsequent total loss of engine power during cruise flight over wooded terrain.NTSB ATL94LA170Accident · 1 fatalLimited investigationFinal reportPiper J-5A · Raeford, NCThe pilot's ostentatious display which resulted in a loss of control of the airplane.NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.NTSB ANC94LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nondalton, AKThe pilot's improper flare during the landing touchdown. The pilot's lack of familiarity with the aircraft make and model was a factor in the accident.NTSB SEA94LA235Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Coolin, IDThe failure of the engine manufacturer to properly remanufacture and adequately inspect the no. 1 rocker arm prior to its installation on the engine. This resulted in fatigue cracking of the rocker arm and a subsequent loss of engine power.NTSB SEA94LA234Accident · No injuriesLimited investigationFinal reportCessna A185F · Conrad, MTThe cfi's failure to assure an adequate inspection of the aircraft, including the proper engagement and function of the rudder pedals, prior to the flight.NTSB NYC94LA170Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Houlton, MEInadequate maintenance inspection which failed to detect internal corrosion of the magneto, resulting in ignition arcing and the loss of engine power.NTSB MIA94LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLThe pilot-in-command's decision to land with excessive airspeed, and failure to obtain the proper touchdown point during a precautionary landing. The electrical short was a factor in the accident.NTSB LAX94FA355Accident · 1 fatalField investigationFinal reportCessna 310H · Reno, NVThe pilot's failure to maintain minimum control airspeed.NTSB CHI94LA316Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot-in-command's (CFI) delayed recovery from a practice autorotation. A factor associated with the accident was the student pilot's improper autorotation.NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.NTSB ANC94LA132Accident · No injuriesLimited investigationFinal reportJames Chisum CHISUM-SCRAPS · Fairbanks, AKThe failure of the pilot to maintain directional control of the airplane. Factors in the accident were the soft terrain and inadequate remedial action.NTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.NTSB NYC94LA171Accident · Serious injuriesLimited investigationFinal reportCessna 152-II · Enfield, NYThe pilot-in-command's attempt to take off under conditions beyond the performance capabilities of the airplane.NTSB SEA94LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Paradise, WAProper altitude was not maintained and improper inflight planning/decision. Factors to the accident were mountainous/hilly terrain conditions and lack of total experience.NTSB LAX94FA354Accident · 4 fatalField investigationFinal reportStinson 108-3 · Shelter Cove, CAInadequate preflight by the pilot, which resulted in fuel starvation and loss of engine power, improper (or delayed) positioning of the fuel selector to the fullest tank, and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced…NTSB LAX94FA353Accident · 4 fatalField investigationFinal reportCessna 172RG · Truckee, CAFailure of the pilot to obtain/maintain adequate airspeed to climb after takeoff, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: high density altitude, improper trim setting for takeoff, the…NTSB FTW94LA292Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Elbert, COThe pilot's inadequate compensation for the winds. A factor was the unfavorable variable winds.NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.