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 ANC12TA008Accident · No injuriesFinal reportBellanca 8GCBC · Delta Junction, AKIce accretion in the main landing gear wheel brakes, which prevented the main landing gear wheels from rotating on landing, which resulted in the airplane nosing over.NTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB ERA12LA069Accident · No injuriesLimited investigationFinal reportGrenier Raymond Vans Aircraft RV-8 · Nashua, NHThe right main landing gear collapse due to the overload fracture of the hardware for reasons that could not be determined during postaccident testing and examination.NTSB WPR12LA029Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Diego, CAThe flight instructor's inadequate supervision of the student pilot during a simulated autorotation and the pilots’ failure to use carburetor heat while operating at reduced engine power while in carburetor icing conditions, which resulted in a loss of engine…NTSB ERA12LA070Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kissimmee, FLA fatigue failure of the right main landing gear pivot assembly, which prevented the landing gear from extending.NTSB ERA12LA071Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S205-22R · Okeechobee, FLA partial loss of engine power due to a failure of the drive bearings in the alternator drive system. Contributing to the accident was the inadequate maintenance.NTSB ERA12CA059Accident · Minor injuriesData collectionFinal reportBeech F33A · Chesterfield, VAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.NTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB ERA12CA047Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Dyersburg, TNThe pilot's inadvertent excessive braking during the landing roll.NTSB CEN12CA036Accident · No injuriesData collectionFinal reportCessna 210J · West Chicago, ILThe pilot's failure to extend the landing gear before touchdown due to his failure to use a checklist.NTSB ANC12CA004Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Aniak, AKThe pilot's excessive use of brakes during landing.NTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.NTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.NTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.NTSB WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.NTSB ERA12FA023Accident · Minor injuriesField investigationFinal reportSocata TBM 700 · Hollywood, FLThe pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…NTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.NTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.NTSB ERA12CA028Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Culpeper, VAThe pilot's inadequate knowledge of the airplane's emergency gear extension procedures, which resulted in his failure to successfully perform a manual extension of the landing gear.NTSB CEN12LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Centerburg, OHThe pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.NTSB ERA12CA013Accident · Minor injuriesData collectionFinal reportLoehle Loehle P-40 · Tullahoma, TNThe pilot's delayed decision to abort the takeoff.NTSB ERA12FA002Accident · 1 fatalField investigationFinal reportTemco GC-1B · Ewell, MDThe pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB CEN11CA679Accident · No injuriesData collectionFinal reportWaltman Theodore J Moose · Hays, KSRudder flutter due to the design changes to the airplane's horizontal stabilizer.NTSB ERA11LA507Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Atlanta, GAThe improper installation of the nose landing gear strut and subsequent collapse of the nose landing gear during landing.NTSB ANC11TA109Accident · No injuriesFinal reportCub Crafters CC18-180 · Palmer, AKThe pilot's excessive application of the brakes during landing, which resulted in a nose-over.NTSB WPR11CA468Accident · No injuriesData collectionFinal reportBeech 36 · Riverton, WYThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB ERA11LA502Accident · Serious injuriesLimited investigationFinal reportCessna P210N · South Deerfield, MAThe failure of the electrical system due to an alternator failure during flight in instrument meteorological conditions, and the pilot’s inadequate preflight inspection and failure to use the approved checklist for the dual alternator system. Contributing to…NTSB WPR11LA460Accident · Serious injuriesLimited investigationFinal reportPiper PA23 · Truckee, CAThe pilot's failure to maintain an airspeed at or above the airplane's minimum controllable airspeed, which resulted in a loss of airplane control. Contributing to the accident was the partial loss of power from the left engine as a result of a clogged fuel…NTSB CEN11LA658Accident · No injuriesLimited investigationFinal reportMark Divita RV-8 · Lancaster, TXThe failure of the tailwheel to remain locked during a crosswind landing, which resulted in a loss of directional control.NTSB WPR11LA451Accident · No injuriesLimited investigationFinal reportPeter A Land White Lightning · Lancaster, CAA total loss of engine power during the landing approach due to fuel starvation. Contributing to the accident was the airplane’s inaccurate fuel indicator.NTSB CEN11LA635Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Waukegan, ILThe pilot’s inadequate preflight inspection of the airplane, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the accident were a malfunctioning fuel gauge and air traffic that prevented an on airport landing.NTSB CEN11CA661Accident · No injuriesData collectionFinal reportLuscombe 8A · Huntington, INThe failure of the right main landing gear strut due to internal corrosion.NTSB CEN11LA632Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18-150 · Long Lake, WIThe pilot's failure to complete the prelanding checklist, which resulted in the landing gear wheels not being retracted for the water landing.NTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.NTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…NTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.NTSB ENG11IA047Incident · No injuriesIncident investigationFinal reportEmbraer EMB145 · Moline, ILThe uncommanded left deflection of the airplane's nose wheel likely due to seal deterioration and subsequent contamination within the Electrohydraulic Servo Valve (EHSV). Contributing to the incident was the undersized condition of the filter plugs within the…NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…NTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.NTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…NTSB CEN11CA640Accident · No injuriesData collectionFinal reportCessna T210M · Cahokia, ILA failure of a spring in the main landing gear actuation system that prevented the landing gear from extending.