NTSB investigations, 2012
20 cases where NTSB found Scheduled/routine maintenance.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 14 |
| 2010 | 17 |
| 2011 | 19 |
| 2012 | 20 |
| 2013 | 21 |
| 2014 | 17 |
| 2015 | 24 |
| 2016 | 21 |
| 2017 | 27 |
| 2018 | 20 |
| 2019 | 19 |
| 2020 | 16 |
| 2021 | 15 |
| 2022 | 18 |
| 2023 | 19 |
| 2024 | 23 |
| 2025 | 5 |
Where
Latest cases
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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02062010'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02062010')) 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 CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13LA091Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Halfway, MOThe pilot's failure to properly maintain the airplane and engine, which resulted in a total loss of engine power due to improperly installed magnetos and a broken camshaft.NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB WPR13CA018Accident · No injuriesData collectionFinal reportAlbright Stan Kitfox Super Sport · Twin Bridges, MTThe airplane builder’s failure to rig the flight controls correctly, which resulted in a loss of control after takeoff.NTSB ERA13LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Allentown, PAThe operator's failure to perform magneto inspections per the manufacturer's recommendations and failure to comply with the engine manufacturer's recommended time interval for engine overhaul, which resulted in defects in the magnetos going undetected and the…NTSB WPR12LA423Accident · No injuriesLimited investigationFinal reportBarney Stardustrer SA-100 · Chandler, AZA loss of engine power as a result of fuel exhaustion due to a fuel line failure. Contributing to the accident was the pilot’s failure to adhere to the maintenance inspection criteria for the airplane.NTSB WPR12FA332Accident · No injuriesField investigationFinal reportPiaggio P180 · Henderson, NVThe failure of maintenance personnel to properly torque the elevator attachment hardware in accordance with the maintenance manual, which led to the detachment of the elevator. Contributing to the accident were maintenance personnel's failure to identify the…NTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB CEN12LA491Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fergus Falls, MNA total loss of engine power due to a cracked No. 2 cylinder head.NTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…NTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.NTSB CEN12LA401Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Baltic, OHLoss of engine power due to fuel starvation as a result of particulate contaminant on the carburetor screens.NTSB CEN12LA343Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Denver, COThe inadequately overhauled landing gear dampers that allowed initiation of a ground resonance event from which the pilot was unable to recover. Contributing to the accident was the overhaul facility's failure to identify the overcharged dampers and a lack of…NTSB CEN12LA353Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Chesterfield, MOThe undercharged and overcharged landing gear dampers, which allowed initiation of the ground resonance event from which the pilot was unable to recover due to his limited experience in helicopters. Contributing to the accident was the ineffective damper…NTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.NTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.NTSB CEN12LA203Accident · 1 fatalLimited investigationFinal reportEnbody Frank GY 201 Minicab · Granite Shoals, TXA loss of engine power due to fuel starvation as a result of a contaminated carburetor fuel screen. Contributing to the accident was the pilot's impairment from medications that degraded his decision-making and the pilot's improper maintenance of the airplane.NTSB ERA12LA246Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Beaver Falls, PAThe operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.NTSB ERA12IA237Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Warrenton, VAMaintenance personnel's failure to identify stress corrosion cracking in the stabilator control cable during the most recent inspection, and the subsequent failure of the cable on the flight after the inspection.