NTSB investigations
3,633 cases where NTSB found Aircraft systems.
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0102')) 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 c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0102')) 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 WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ENG12IA024Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hays, KSA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN12CA185Accident · No injuriesData collectionFinal reportCessna 180H · Belle Chase, LAThe bent tailwheel spring that allowed the tailwheel to caster when the airplane encountered a wind gust on landing roll.NTSB ERA12LA217Accident · No injuriesLimited investigationFinal reportCessna 310K · Olive Branch, MSFuel leaking from the left engine fuel strainer onto electrical connections after engine start, which resulted in a fire.NTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.NTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…NTSB CEN12LA204Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Roanoke, TXThe pilot’s failure to follow the published emergency procedures to lower the landing gear following a loss of electrical power.NTSB CEN12FA164Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Albany, TXThe loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…NTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.NTSB CEN12LA218Accident · No injuriesLimited investigationFinal reportCessna 182A · New Philadelphia, OHThe inadequate maintenance of the wheel attachment bolts, which resulted in the left wheel separating from the landing gear during landing due to ductile overstress fractures.NTSB ENG12IA014Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB ERA12IA187Incident · No injuriesIncident investigationFinal reportCessna 402B · Fort Lauderdale, FLThe overload fracture of the right main landing gear bellcrank and a securing bolt, which resulted in the collapse of the right main landing gear.NTSB ERA12LA188Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Culpeper, VAThe pilot's failure to use the manufacturer's checklist to troubleshoot the perceived malfunction and thereby ensure the position of the landing gear before landing. The reason the landing gear were not down and locked could not be determined, as no…NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.NTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.NTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…NTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB ANC12LA017Accident · No injuriesLimited investigationFinal reportPzl-Swidnik SW-4 · Fairbanks, AKA loss of control during a simulated hydraulic emergency, which resulted in an inadvertent dynamic rollover from the which the pilot could not recover.NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…NTSB ERA12CA140Accident · No injuriesData collectionFinal reportLuscombe 8A · Umatilla, FLA failure of the left main landing gear due to a preexisting crack and corrosion, which resulted in a loss of directional control during landing.NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.NTSB CEN12LA128Accident · No injuriesLimited investigationFinal reportSanderson Pitts Special SPS-1 · Revere, MNThe total loss of engine power during cruise flight due to fuel contamination and the inadequate design of the fuel system.NTSB CEN12CA132Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Del Norte, COThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident were the sensitivity of the brake system and the certified flight instructor pilot's delayed remedial action.NTSB ERA12LA131Accident · No injuriesLimited investigationFinal reportHaney John F B Seastar XP · Willimantic, CTA partial loss of engine power due to carburetor icing. Contributing to the accident was the lack of an installed manufacturer-recommended carburetor heat system.NTSB CEN12LA127Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Marion, TXA total loss of engine power due to fuel starvation as a result of a piece of metal in the fuel line, which blocked fuel flow to the engine.NTSB ERA12FA127Accident · No injuriesField investigationFinal reportCessna 650 · Ft. Lauderdale, FLThe crew's failure to use proper emergency procedures during an uncommanded right roll after takeoff, which led to a forced landing with a quartering tailwind. Contributing to the accident was a faulty right roll spoiler actuator, which allowed the right roll…NTSB CEN12LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot’s inadvertent positioning of the fuel selector valve between the right tank and OFF position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate inspection of the fuel valve and…NTSB WPR12LA070Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Concord, CAThe pilot's inadequate preflight inspection of the airplane and the subsequent total loss of engine power as a result of debris and water contamination in the fuel system.NTSB ERA12LA126Accident · No injuriesLimited investigationFinal reportClassic Waco YMF5 · Marathon, FLThe pilot did not ensure that there was sufficient fuel aboard the airplane before initiating the flight, which resulted in temporary fuel starvation and an interruption in engine power during maneuvering. Contributing to the accident was the pilot’s decision…NTSB ERA12LA117Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe mechanic's improper installation and lubrication of the bushing on the right main landing gear truss assembly, which resulted in the landing gear not locking in the down position.NTSB DCA12CA023Accident · No injuriesData collectionFinal reportUniversity Of Kansas Meridian · McMurdo, AYan aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…NTSB ANC12CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Kaltag, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's self-reported fatigue.NTSB ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB WPR12LA052Accident · No injuriesLimited investigationFinal reportBeech 76 · San Carlos, CAThe collapse of the right main landing gear during the turn off the runway due to the failure of the A-frame assembly.NTSB ERA12IA097Incident · No injuriesIncident investigationFinal reportCessna 560XL · Ocoee, FLWater contamination in the pitch trim actuators.NTSB CEN12LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Fredericksburg, TXThe pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.NTSB ERA12IA090Incident · No injuriesIncident investigationFinal reportCessna 402B · Nantucket, MAThe failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…NTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB CEN12LA087Accident · No injuriesLimited investigationFinal reportAviat A-1B · Gainesville, TXThe right main gear tire contacting the brake caliper, which resulted in an uncommanded brake effect on the wheel.NTSB ANC12CA010Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKA broken wheel/ski clevis pin, which allowed the ski to pivot upward and strike the right wing lift strut.NTSB ERA12CA079Accident · No injuriesData collectionFinal reportBeech C-45G · Lyman, MSThe collapse of the right main landing gear during landing due to an encounter with soft terrain.NTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.NTSB ERA12FA074Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Ulysses, PAThe total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…NTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.NTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.