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 CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…NTSB ATL96LA097Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksboro, TNloss of engine power for undetermined reason(s), which resutled in a forced landing and subsequent in-flight collision with trees and the terrain.NTSB ANC96LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot of the Cessna 180, N5020E, disregard of an air traffic control clearance/instruction to hold short. A factor in the accident was the failure of both pilots to maintain an adequate visual lookout for other aircraft.NTSB NYC96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Newry, PAfailure of the pilot to identify the inoperative airspeed indication and abort the takeoff, while there was sufficient runway remaining; excessive speed during the approach/landing; and the pilot's failure to perform a go-around after not attaining a proper…NTSB NYC96LA134Accident · No injuriesLimited investigationFinal reportWsk Pzl-Krosno KR-03A · Hilltown, PAfailure of a bolt on the tow hook which resulted in an uncommanded release of the tow rope, and forced landing of the glider.NTSB MIA96LA166Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Lorida, FLfailure of company maintenance personnel to properly torque the tail rotor 90 degree gear box mounting bolts during installation, which resulted in failure of the mounting studs due to bending fatigue and subsequent separation of the gearbox.NTSB MIA96FA168Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Webster, FLinadequate compliance with AD 77-07-08 (and SB FH1100-55-2A) by other maintenance personnel, and subsequent fatigue failure of plates in the tail rotor torsion tension bar. Factors related to the accident were: manufacturing discontinuities…NTSB FTW96LA284Accident · No injuriesLimited investigationFinal reportBeech B35 · Portales, NMfailure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.NTSB FTW96LA278Accident · Serious injuriesLimited investigationFinal reportRyan PT-22 · Krum, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was his lack of recent experience in the make and model of airplane.NTSB CHI96LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Windfall, INfailure of the pilot to maintain adequate airspeed, while maneuvering to avoid an obstruction (transmission line), which resulted in a stall and collision with the terrain. His lack of familiarity with the geographic area was a related factor.NTSB CHI96LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Bad Axe, MIa deer that ran onto the runway. The light condition at dusk was a related factor.NTSB SEA96FA137Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Pray, MTthe pilot's delay in initiating a go-around, and his failure to obtain and/or maintain sufficient airspeed to avoid higher terrain during the go-around, which resulted in a stall and collision with terrain. Factors relating to the accident were: the narrow…NTSB MIA96LA167Accident · Minor injuriesLimited investigationFinal reportBeech B55B · Clinton, NCa loss of right engine power for undetermined reasons, resulting in the pilot loosing control of the airplane and impact with tress.NTSB LAX96LA260Accident · No injuriesLimited investigationFinal reportCessna P210N · San Bernardino, CAfailure of the landing gear to go and/or remain in a down-and-locked condition for undetermined reason(s).NTSB LAX96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 150H · San Carlos, CAThe failure of the flaps to retract due to the installation of an incorrect fuse and the inadequate maintenance/inspections performed on the system; and the pilot-in-command's failure to maintain an adequate airspeed while maneuvering for a forced landing,…NTSB FTW96LA277Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Providence, LAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise motion of the airplane and subsequent damage.NTSB CHI96LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIthe pilot's failure to maintain directional control of the airplane during landing. A factor was the delayed go-around.NTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.NTSB NYC96LA132Accident · No injuriesLimited investigationFinal reportCessna 140A · Edinboro, PAThe pilot's improper flare, which resulted in a hard landing and subsequent nose over. The tailwind was a related factor.NTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.NTSB LAX96LA247Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Oroville, CAundetermined.NTSB IAD96LA101Accident · No injuriesLimited investigationFinal reportCessna 182P · White Marsh, MDThe pilot's improper flare which resulted in a hard landing. A related factor was the pilot's improperly planned approach.NTSB CHI96LA219Accident · No injuriesLimited investigationFinal reportNavion NA1 · Evansville, INthe pilot did not maintain control of the aircraft during landing roll.NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.NTSB ANC96TA092Accident · No injuriesFinal reportHughes 369D · Ketchikan, AKThe pilot's failure to maintain control of the helicopter. The pilot's selection of unsuitable terrain for landing was a factor in the accident.NTSB NYC96IA131Incident · No injuriesIncident investigationFinal reportBoeing 767-332ER · Jamaica, NYthe improper installation of the generator feed cable by the manufacturer, which resulted in a severed aileron cable due to arcing between the generator feed cable and aileron cable.NTSB MIA96LA163Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Callahan, FLthe pilot's premature decision to reduce power, following application of carburetor heat, when engine operation became rougher after experiencing roughness due to carburetor icing. The weather (carburetor icing) conditions and carburetor ice were related…NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.NTSB CHI96LA215Accident · No injuriesLimited investigationFinal reportLoehle-Avia 5151RG · Fond Du Lac, WIthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.NTSB CHI96FA216Accident · No injuriesField investigationFinal reportFairchild SA227AC · Grand Forks, NDinsufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.NTSB MIA96FA165Accident · 1 fatalField investigationFinal reportBeech P35 · St. Petersburg, FLthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel.NTSB FTW96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · El Paso, TXloss of directional control due to the failure of the tailwheel lock. A factor was the crosswind.NTSB FTW96LA275Accident · No injuriesLimited investigationFinal reportRockwell S2R · Las Animas, COinadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the unfavorable wind condition for takeoff, and the terrain condition beyond the end of the runway.NTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.NTSB FTW96LA273Accident · No injuriesLimited investigationFinal reportWilliams Velocity 173RG · Longmont, COthe pilot's improper planning/decision. Factors relating to the accident were: the high density altitude, and the pilot's inadequate weather evaluation.NTSB FTW96LA270Accident · Minor injuriesLimited investigationFinal reportAmerican AG5B · Longmont, COAn inadvertent stall spin. Factors were the pilot's intentional maneuver at an altitude insufficient to ensure a safe recovery, and overconfidence in his personal ability.NTSB CHI96LA235Accident · No injuriesLimited investigationFinal reportBeech B35 · Chesterfield, MOimproperly balanced ruddervators and improperly installed ruddervator (elevator) trim tabs, due to improper maintenance, which resulted in ruddervator flutter and substantial damage in the area of the aft fuselage. Factors relating to the accident were:…NTSB CHI96LA210Accident · 1 fatalLimited investigationFinal reportFarland Genesis · Le Sueur, MNthe pilot's impairment of judgment and performance due to drugs, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and collision with terrain. Factors related to the accident were: the pilot's limited aeronautical…NTSB ATL96FA095Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Clanton, ALcorrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.NTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.NTSB NYC96LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Block Island, RIthe pilot's inadequate preflight, by failing to remove the control lock and checking the flight controls before takeoff, and his failure to abort the takeoff in a timely manner, which resulted in an overrun, an encounter with brush, and a subsequent nose over…NTSB MIA96WA169Accident · 2 fatalForeign investigationPiper PA-18-C23 · Iztapa, GuatemalaNTSB MIA96FA162Accident · No injuriesField investigationFinal reportEmbraer 120 · Orlando, FLthe aircraft manufacture's inadequate written procedures in the airplane flight manual/quick reference handbook, which resulted in a failure of the landing gear to extend and a wheels up emergency landing, due to hydraulic blockage in the landing gear…NTSB LAX96LA243Accident · No injuriesLimited investigationFinal reportMini Ace CA61-F · Byron, CAThe pilot's encounter with a sudden crosswind gust beyond the capabilities of the aircraft.NTSB LAX96LA242Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Avalon, CAThe failure of the left brake for undetermined reasons.NTSB LAX96LA241Accident · No injuriesLimited investigationFinal reportCessna 182 · Mendota, CAThe pilot's decision to intentionally shut down the engine; his failure to verify the surface winds during the prolonged orbiting descent over the airport, which resulted in a final approach with a tailwind component; and his misjudging of the aircraft's…NTSB CHI96LA214Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Union, ILThe pilots misjudgment of the altitude and distance to the runway.NTSB CHI96LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Conway, MIA crack in the intake manifold which led to oil exhaustion and subsequent piston failure. A factor was the soft field.NTSB SEA96LA160Accident · No injuriesLimited investigationFinal reportCessna 182A · Toledo, WAloss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.NTSB MIA96LA161Accident · No injuriesLimited investigationFinal reportCessna 170A · Southside, ALfailure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…