NTSB investigations, 2001
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2001 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 WHERE year(c."eventDate") = 2001 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 LAX01LA163Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Maria, CAA stall/mush inadvertently encountered by the pilot-in-command. Failure to maintain adequate airspeed for flight and inadequate remedial action contributed to the accident.NTSB DEN01LA100Accident · No injuriesLimited investigationFinal reportCessna T206H · Watkins, COthe pilot's failure to maintain the proper decent rate during the flare resulting in a hard landing. Contributing factors icing conditions and accumulations of wing ice.NTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.NTSB SEA01TA083Accident · No injuriesFinal reportde Havilland DHC-6-300 · Star, IDFatigue failure of the nose wheel steering cable during the landing roll. Rough/uneven terrain was a factor.NTSB LAX01FA160Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Casa Grande, AZA fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…NTSB FTW01FA111Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · The Woodlands, TXThe pilot's failure to maintain airplane control following a loss of right engine power, which resulted in impact with terrain in an uncontrolled descent. A contributing factor was the loss of right engine power as a result of the fatigue failure of the…NTSB CHI01FA129Accident · Minor injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe partial failure of the aircraft tug for undetermined reasons.NTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.NTSB SEA01LA080Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T45 · Royal City, WALoss of engine power for undetermined reasons. Trees were a factor.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB IAD01FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Afton, VAThe pilot's loss of consciousness due to a medical condition, which resulted in his failure to maintain control of the airplane and subsequent impact with rising terrain.NTSB FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB MIA01WA142Accident · 1 fatalForeign investigationCessna C-208 Caravan · Nagambie, AustraliaNTSB LAX01LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Henderson, NVThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion and a forced landing in rough terrain.NTSB IAD01TA051Accident · Minor injuriesFinal reportHughes 369D · Taylorsville, KYthe flight instructor's inadequate aircraft control during a practice autorotation which resulted in a hard landing.NTSB IAD01LA050Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Clarksburg, WVThe pilot's failure to perform fuel consumption calculations and incorrect positioning of the fuel tank selector, which resulted in fuel starvation of the engine.NTSB FTW01LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Pleasanton, TXthe student pilot's failure to maintain directional control during the landing flare/touchdown. Contributory factors were the gusty wind and the student pilot's lack of total flight experience.NTSB FTW01LA108Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain directional control during the takeoff initial climb. Contributory factors were the pilot's lack of experience with the aircraft and the soft terrain.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.NTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.NTSB MIA01WA133Accident · 10 fatalForeign investigationCessna 208B · Roque Perez, ArgentinaNTSB MIA01LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Wilmington, NCA total loss of engine power due to the failure of maintenance to properly secure the fuel selector cover, resulting in the pilot inadvertently selecting "off" instead of "left" tank, and the subsequent forced landing to uneven terrain.NTSB MIA01LA135Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Greenville, SCThe failure of the pilot to obtain the assistance of a person to act as a safety pilot while hand propping the engine with the airplane tied down. A factor in the accident was the failure of the tie down rope.NTSB LAX01LA161Accident · Serious injuriesLimited investigationFinal reportTaylor Bandit · Marysville, CAThe pilot performed an inadequate preflight inspection resulting in a loss of engine power at a low altitude because of water contamination.NTSB LAX01LA141Accident · 1 fatalLimited investigationFinal reportMotley Vans RV-6A · Baker, CAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude, which led to an inadvertent stall/spin. The wind gusts were a factor.NTSB IAD01LA052Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Annapolis, MDpilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB FTW01LA110Accident · No injuriesLimited investigationFinal reportPerlick Avid Commuter · Crawford, TXthe loss of engine power on takeoff initial climb due to fuel starvation as a result of an air blocked fuel line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01FA107Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Rockwall, TXthe loss of directional control during landing roll as a result of insufficient nose gear steering authority.NTSB DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.NTSB NYC01LA108Accident · 1 fatalLimited investigationFinal reportBensen Gyroplane · Watertown, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in rotary wing aircraft.NTSB MIA01WA154Accident · No injuriesForeign investigationPiper PA-23-250 · Carrasco, UruguayNTSB MIA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Venice, FLThe failure of the pilot to attain the proper touchdown point resulting in a long landing and subsequent collapse of the right main landing gear. Also, failure of the pilot to perform a go-around following a long landing.NTSB FTW01LA114Accident · Serious injuriesLimited investigationFinal reportBoykin B J B8M · Clarksville, ARthe pilot's inadequate preflight inspection, which resulted in a loose control stick on takeoff, rendering the aircraft uncontrollable.NTSB FTW01LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Nacogdoches, TXthe pilot's failure to maintain clearance with the wires during takeoff. Contributory factors were the sunglare and the unmarked wires.NTSB DEN01LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · St. George, UTthe pilot's failure to sump all the fuel drains during preflight and the subsequent loss of power in the right engine during takeoff, the pilot feathering the wrong engine's propeller during the forced landing, the pilot improperly raising the landing gear…NTSB SEA01LA079Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Summer Lake, ORthe pilot's decision to land on a dry lake bed without first taking action to determine the firmness of the surface. Factors include soft terrain at the location the pilot chose to land.NTSB MIA01LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 42-300 · Atlantic Ocean (Atlantic Ocean)The in-flight encounter with moderate to severe turbulence in clouds resulting in the serious injury to the flight attendant. A contributing factor in the accident was the poor in-flight planning by the captain for his allowing beverage service to continue…NTSB MIA01LA130Accident · No injuriesLimited investigationFinal reportCessna 210N · Gainesville, FLThe pilot's delay in securing all non-essential electrical equipment in-flight resulting in battery depletion before complete gear extension was accomplished using the normal system and subsequent collapse of the main landing gear. A contributing factor in…NTSB MIA01IA129Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Nashville, TNThe failure of company maintenance personnel to install the correct hydraulic landing gear extension component, and the failure of company maintenance inspection personnel to comply with proper post maintenance test procedures, resulting in the impossibility…NTSB IAD01LA048Accident · No injuriesLimited investigationFinal reportCessna 208B · Plattsburgh, NYThe incorrect installation of the propeller reversing lever and carbon block assembly, which resulted in a loss of propeller thrust.NTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB FTW01FA104Accident · 1 fatalField investigationFinal reportCessna 402B · Del Rio, TXthe loss of control due to a jammed trim tab, which resulted from the failure of maintenance personnel to properly secure the trim tab actuator rod when installing a replacement elevator.NTSB DEN01LA091Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Columbus, NMThe impact with terrain following an inadvertent stall/mush by the pilot during a go-around. A contributing factor was a dust devil.NTSB DEN01FA090Accident · Serious injuriesField investigationFinal reportPiper PA-39 · Fort Collins, COthe loss of right engine power on take-off as a result of the separation of the right engine's alternate air door, which lodged in the fuel servo air inlet. A factor was the lack of suitable terrain for a forced landing.NTSB ANC01LA070Accident · No injuriesLimited investigationFinal reportCessna 207A · Deadhorse, AKThe pilot's failure to maintain altitude/clearance while maneuvering. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB SEA01WA078Accident · No injuriesForeign investigationCessna TR182 · Bella Bella, BC, CanadaNTSB NYC01IA107Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Norfolk, VAThe manufacturer's inadequate quality control, which resulted in a jammed elevator trim actuator.