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 MIA94LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Naples, FLFailure of the pilot-in-command to maintain wingtip clearance while taxiing resulting in the on-ground collision with a light pole.NTSB FTW94LA248Accident · Serious injuriesLimited investigationFinal reportScorpion 133 · Fredricksburg, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty wind and the non-certificated pilot's inadequate training.NTSB FTW94LA247Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Tyler, TXThe pilot's failure to refuel.NTSB FTW94LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pollard, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB SEA94FA194Accident · 2 fatalField investigationFinal reportHughes 369HS · Seaside, ORInflight collision with terrain for undetermined reasons.NTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedNTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.NTSB NYC94LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Waynesburg, OHThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. A factor was a tailwind.NTSB NYC94FA135Accident · 2 fatalField investigationFinal reportMooney M20C · Wallingford, CTthe pilot's decision to exhaust the fuel supply in the selected tank in-flight, and his failure to maintain the minimum stall speed during engine out conditions. This resulted in a complete loss of engine power and the inadvertent stall and impact with the…NTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.NTSB MIA94LA182Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Atlantic Ocean (Atlantic Ocean)An electrical system short for undetermined reasons.NTSB MIA94IA183Incident · No injuriesIncident investigationFinal reportCessna 402C · St. Petersburg, FLCollapse of the right main landing gear during the landing roll for undetermined reasons.NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.NTSB LAX94LA295Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Jackson, CAthe pilot's inadequate compensation for the gust of wind and subsequent loss of directional control.NTSB FTW94LA250Accident · No injuriesLimited investigationFinal reportLet L-23 · Stillwater, OKThe certified flight instructor's failure to maintain flying speed.NTSB FTW94LA243Accident · No injuriesLimited investigationFinal reportCameron V-77 · Pflugerville, TXThe pilot's failure to maintain control. A factor was the unfavorable wind.NTSB ATL94LA144Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hephzibah, GAThe pilot's inadequate preflight of the aircraft, resulting in fuel exhaustion, and his improper flare of the helicopter during the autorotation, resulting in a hard landing.NTSB ANC94LA092Accident · No injuriesLimited investigationFinal reportCessna A185F · Anchorage, AKThe pilot misjudged the landing flare. A factor in the accident was the glassy water.NTSB FTW94LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Owasso, OKThe pilot's failure to attain the proper touchdown point.NTSB FTW94FA242Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Lakeview, ARThe pilot's failure to maintain minimum required airspeed for flight.NTSB CHI94LA243Accident · Serious injuriesLimited investigationFinal reportInman Acro Sport 1 · Albert Lea, MNthe pilot's failure to make a precautionary landing on the remaining runway. Factors in the accident were the blocked fuel injector and inadvertent stall.NTSB CHI94LA241Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Eckelson, NDthe pilot's failure to maintain clearance from a transmission wire. A factor associated with the accident is the transmission wire.NTSB CHI94LA240Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Wymore, NEfailure of the fuel injector pump due to improper assembly.NTSB ANC94LA093Accident · No injuriesLimited investigationFinal reportCessna 150 · Melozzi Hot Sps, AKThe pilot's premature lift off below the stall speed of the airplane.NTSB SEA94LA192Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Bremerton, WAThe pilot-in-command's failure to maintain directional control during landing.NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.NTSB SEA94LA189Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Seattle, WAThe proper touchdown point was misjudged by the pilot. During the go-around attempt, he failed to maintain clearance from obstacles.NTSB LAX94LA294Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ligurta, AZThe pilot's failure to assure the suitability of the landing area prior to the flight. The dark night and the badger hole were factors in the accident.NTSB FTW94LA252Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waller, TXThe pilot's failure to maintain proper clearance during takeoff.NTSB FTW94LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Englewood, COAn inadvertent stall. Factors were the airplane's maximum gross weight and climb capability were exceeded, and a high density altitude.NTSB CHI94LA242Accident · No injuriesLimited investigationFinal reportGrumman FM-2 · Woodburn, INthe total failure of the throttle linkage arm.NTSB CHI94LA236Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Cottage Hill, ILthe pilot inadequate preflight planning/preparation and his inaccurate fuel consumption calculations.NTSB ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB SEA94LA187Accident · No injuriesLimited investigationFinal reportBeech P-35 · Laramie, WYLoss of engine power for undetermined reasons. Factors include fence posts struck during rollout at the emergency landing site.NTSB NYC94LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Chatham, MAThe pilot's failure to see and avoid the birds. The presence of the birds at the airport was a contributing factor.NTSB FTW94LA249Accident · No injuriesLimited investigationFinal reportCessna 140 · Archer City, TXFuel contamination induced power loss. Factors were the improper refueling techniques used by the pilot and the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW94FA241Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Foules, LAThe pilot's failure to maintain obstacle clearance.NTSB CHI94LA239Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marinette, WIThe pilot's inadequate compensation for the wind conditions encountered. Factors associated with this accident were the pilot's inadequate remedial action and the gusty wind conditions.NTSB ANC94LA091Accident · No injuriesLimited investigationFinal reportCessna T207A · Haines, AKFuel starvation as a result of the pilot's improper in-flight planning/decision and his failure to follow the procedures contained in the airplane checklist for engine failure.NTSB MIA94FA181Accident · Serious injuriesField investigationFinal reportBellanca 14-9 · Lakeland, FLThe improper modification of the engine driven fuel pump mechanical arm by an unknown person, restricting the fuel systems ability to supply fuel to the engine at full power.NTSB FTW94LA240Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Moriarity, NMThe pilot's inadequate compensation for wind conditions and the high density altitude. Factors were gusty wind conditions, downdrafts and the degraded engine performance due to pervious detonation damage.NTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.NTSB CHI94LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Traverse, MIpoor preflight planning and preparation by the pilot for not calculating the weight and balance of his airplane before departure. Factors associated with the accident were the airplane's weight and balance was exceeded, and the pilot's lack of recent…NTSB ATL94LA151Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Columbus, GAThe dual student's failure to properly flare the aircraft during the landing. Factors were the dusk light conditions, and the flight instructor's inadequate supervision of the dual student.NTSB ANC94FA089Accident · No injuriesField investigationFinal reportAerospatiale AS-350 · Juneau, AKThe pilot's selection of unsuitable landing terrain. A factor was the crevasse in the ice.NTSB SEA94LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Wilder, IDThe failure of the left brake master cylinder and the pilot's inadequate remedial action when the aircraft collided with an embankment during an intentional ground loop.NTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.NTSB SEA94LA179Accident · Serious injuriesLimited investigationFinal reportKaman HH43F · John Day, ORFailure of a turbine compressor wheel. The lack of suitable terrain for an autorotation/forced landing was a factor.NTSB NYC94LA133Accident · No injuriesLimited investigationFinal reportHoopes RV-6 · Farmingdale, NJThe pilot's improper decision to fly after donating blood which resulted in his incapacitation.NTSB NYC94LA131Accident · No injuriesLimited investigationFinal reportDonovan DER Kricket 17K-1 · Brockport, NYThe loss of engine power as a result of a sticking valve in the carburetor due to dirt contamination.