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 ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.NTSB SEA90FA125Accident · Serious injuriesField investigationFinal reportCessna T210K · Everett, WAInadequate preflight by the pilot by not assuring that the rudder pedals were properly engaged. A factor related to the accident was: the pilot's lack of familiarity with this make and model of aircraft.NTSB NYC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Washington, PAThe pilot's failure to maintain clearance from objects while taxiing, and his visual lookout was inadequate.NTSB NYC90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · High Point Lake, PAA loss of control upon touchdown and during the go around, which resulted in uncontrolled contact with the windsock and a rock quarry. Contributing was the excessive speed of the aircraft (reported 80 knots) upon initial touchdown.NTSB LAX90LA247Accident · No injuriesLimited investigationFinal reportBeech A-35 · Santa Ynez, CAAn engine failure due to fuel leakage from a ruptured diaphram in the carburetor; failure of the aircraft owner to comply with the manufacturer's recommended component overhaul intervals.NTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.NTSB FTW90LA134Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Gainsville, TXFuel exhaustion due to inadequate planning by the pilot.NTSB FTW90GA137Accident · Minor injuriesFinal reportCessna 404 · San Angelo, TXImproper use of powerplant controls by the pilot-in-command (PIC). Factors related to the accident were: the pic's inadequate crew coordination, and the excessive airspeed and rate of descent that resulted, when the PIC maneuvered the aircraft back on course…NTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.NTSB CHI90DEM06Accident · Serious injuriesFinal reportFunk, D.D. B-85C · White Cloud, MIThe passengers disregard of the pilot's instructions and her failure to maintain clearance from the propeller.NTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.NTSB NYC90LA155Accident · No injuriesLimited investigationFinal reportCessna 305A · Newburyport, MAFailure of the pilot in command to follow procedures for landing with a banner still attached, contributing to the accident was the improper modification of banner release mechanism.NTSB NYC90LA152Accident · Minor injuriesLimited investigationFinal reportCessna C182A · Pepperell, MAInflight collision with terrain during a forced landing after the pilot experienced jammed flaps and a power loss due to the fuel selector being improperly positioned.NTSB LAX90LA246Accident · No injuriesLimited investigationFinal reportSchweizer 300C · San Jose, CAThe pilot's loss of directional control. A factor in the accident was his inadequate compensation for wind conditions.NTSB FTW90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wharton, TXThe loss of power due to an out-of-rig condition in the automatic auxiliary boost pump mechanism.NTSB FTW90FA138Accident · 1 fatalField investigationFinal reportMingess-Bennett M30 · New Braunfels, TXFailure of the pilot in the overtaking aircraft (N97RJ) to see-and-avoid the aircraft that had been leading (N911HG). Factors related to the accident were: the lack of ability for the pilot in the lead aircraft (911HG) to be able see other aircraft in the…NTSB DEN90LA152Accident · No injuriesLimited investigationFinal reportStinson 108 · Clovis, NMImproper installation of the right main wheel assembly.NTSB CHI90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Drummand Island, MIPilot-in-command's failure to plan his approach and landing to use all available runway. Contributing factors are inadequate preflight preparation, lack of familiarity with the destination airport, and inadequate runway markings.NTSB LAX90LA236Accident · No injuriesLimited investigationFinal reportCessna 172RG · Concord, CAThe student pilot's initiating an excessive descent and the cfi's inadequate remedial action.NTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.NTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.NTSB CHI90LA170Accident · No injuriesLimited investigationFinal reportCessna R182 · Lambertville, MIPilot in command's mis-placement of the airplanes landing gear lever in the 'up' position while the airplane was on the ground, thereby allowing the landing gear squat switch, located in the nose gear compartment, to function as a retracting controller during…NTSB CHI90DEP06Accident · 1 fatalFinal reportCessna 177B · Iola, WIFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin. Factors related to the accident were: the pilot's poorly planned approach, and his failure to go around.NTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.NTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.NTSB ATL90LA140Accident · No injuriesLimited investigationFinal reportBeech C24R · Brunswick, NCEngine malfunction for undetermined reasons. A factor in the accident was the unseen ditch with which the airplane collided.NTSB ANC90LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Coldfoot, AKThe airplane encountered a downdraft shortly after takeoff from which the airplane could not overcome with power. Contributing to the accident was the heavily loaded airplane and the engine not developing full power due to improper maintenance.NTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.NTSB NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.NTSB NYC90LA145Accident · No injuriesLimited investigationFinal reportCessna 177B · Danielson, CTThe failure of the pilot to maintain proper runway alignment, and his failure to obtain or maintain adequate airspeed during a go-around, which resulted in an inadvertent stall and collision with the shrubs and trees.NTSB LAX90FA244Accident · 1 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's improper in-flight planning, decision, and his intentional low flying near mountainous terrain. Contributing factors related to the pilot's not maintaining/following proper VFR procedures, the related distraction of the open cabin door, and the…NTSB FTW90LA131Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · College Station, TXThe pic's improper fuel tank selection, allowing both engine to quit due to fuel starvation.NTSB DEN90IA154Incident · No injuriesIncident investigationFinal reportAerospatiale A-300B4 · Denver, COEngine failure due to turbine wheel failure, induced by fatigue.NTSB ANC90FA111Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKThe pilot-in-command's failure to maintain airspeed on initial climbout.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.NTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.NTSB NYC90LA144Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS-3 · South Mountain, PAThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.NTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…NTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.NTSB FTW90LA132Accident · No injuriesLimited investigationFinal reportBeech B19 · Mc Kinney, TXInadequate supervision by the PIC, the instructor pilot, when he allowed the student pilot to flare at too high an altitude off the runway.NTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.NTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.NTSB ANC90LA113Accident · No injuriesLimited investigationFinal reportCessna 180B · Butterfly Lake, AKThe pilot failed to retract the airplane's wheel prior to a water landing. Contributing factors are his failure to follow established procedures/directives, and habit interference caused by his concern over an air traffic conflict during the preceding takeoff.NTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.NTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.NTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.NTSB NYC90LA147Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bedford, NYThe failure of the pilot to monitor the fuel gauges and fuel starvation. A factor related to the accident was the failure of maintenance personnel to detect the bent condition of the rear engine tank fuel selector control cable.NTSB MIA90IA148Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B · Tyndall Afb, FLA propeller blade fatigue failure due to improper overhaul by other maintenance personnel not performing overhaul in accordance with factory service bulletins.