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 NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.NTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB LAX94LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devore, CAwas the failure of the pilot to follow checklist and emergency procedures, which resulted in an improper decision to land on a dirt road within two miles of an airport.NTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75 · Comfort, TXThe pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.NTSB CHI94LA260Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Waterford, MIthe failure of the pilot to maintain directional control.NTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.NTSB CHI94LA252Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Flushing, MIthe pilot's improper touchdown position on the runway. A factor associated with the accident is the moving vehicle on the adjacent road.NTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.NTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.NTSB MIA94LA188Accident · Minor injuriesLimited investigationFinal reportPiper J5C · Yazoo City, MSPartial blockage of the carburetor by a wasp nest, which was not visible during preflight, and which resulted in the loss of power.NTSB LAX94LA305Accident · No injuriesLimited investigationFinal reportCessna 172N · Cameron Park, CAthe pilot's improper use of the elevator control during the landing flare.NTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.NTSB LAX94LA301Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Livermore, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering and his subsequent entry into an inadvertent stall/mush. A factor was fuel starvation due to the pilot's failure to select the proper fuel tank.NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.NTSB ATL94GA148Accident · Minor injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for undetermined reasons.NTSB ANC94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, AKUndetermined.NTSB ANC94LA094Accident · Serious injuriesLimited investigationFinal reportBell 206 · Kenai, AKThe pilot attempting to operate the helicopter in an environment which exceeded the aircraft's performance envelope.NTSB SEA94T#A02Accident · No injuriesClass 3Final reportLockheed P2V-7 · Missoula, MTNTSB SEA94LA200Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Connell, WAThe pilot's failure to maintain airspeed while conducting aerial application activities.NTSB NYC94LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Towanda, PAThe pilot's improper recovery from a bounced landing.NTSB MIA94LA187Accident · No injuriesLimited investigationFinal reportCessna 210-M · Orlando, FLThe improper installation of a nose gear actuator hydraulic line by an unknown person that bent it at installation. Contributing to the accident was the failure of the line allowing all hydraulic fluid to vent overboard disabling the normal and emergency gear…NTSB MIA94LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Palatka, FLThe student pilot's improper landing flare and failure to properly recover from a bounced landing.NTSB LAX94LA302Accident · No injuriesLimited investigationFinal reportCessna 421C · Polacca, AZthe pilot's attempt to make a 180-degree turn in soft sand at a speed which imposed side loading on the nose gear. Factors were the pilot's decision to continue the approach beyond the planned touchdown point, the effect of the runway surface on braking…NTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.NTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.NTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.NTSB CHI94LA250Accident · No injuriesLimited investigationFinal reportCessna 421C · Oshkosh, WIthe pilot-in-command's misjudging the flare and his failure to maintain airspeed.NTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.NTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.NTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.NTSB ATL94LA149Accident · No injuriesLimited investigationFinal reportMiller, John Skybolt · Muscle Shoals, ALThe fatigue failure of the main landing gear strut that resulted in a loss of control.NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.NTSB MIA94LA185Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe pilot-in-command's improper use of carburetor heat. The carburetor icing conditions were a factor.NTSB LAX94LA300Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Elko, NVa loss of engine power from fuel exhaustion due to the pilot's improper preflight and fuel consumption calculations while operating with known equipment malfunctions.NTSB LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.NTSB LAX94LA298Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Corona, CAAn undetermined partial loss of engine power.NTSB FTW94LA251Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COAn inadvertent stall. A factor was the pilot's excessive flare.NTSB CHI94LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Lomax, ILthe pilot's failure to maintain clearance from a transmission wire, and the pilot's failure to maintain an appropriate altitude. A factor associated with the accident is the transmission wire.NTSB CHI94LA245Accident · No injuriesLimited investigationFinal reportMooney M20C · Macon, MOthe student pilot's decision to land on a closed runway under construction. A factor associated with the accident is the partial loss of engine power for an undetermined reason.NTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.NTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.NTSB NYC94LA139Accident · No injuriesLimited investigationFinal reportCessna 172A · Block Island, RIThe pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.NTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.NTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.NTSB ANC94LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe partial loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.NTSB NYC94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lumberton, NJThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain directional control during an aborted landing. A factor is the pilot's improper landing flare.