NTSB investigations, 2012
12 cases where NTSB found Maintenance, general.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 10 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 12 |
| 2013 | 13 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 10 |
| 2019 | 4 |
| 2020 | 8 |
| 2021 | 5 |
| 2022 | 8 |
| 2023 | 6 |
| 2024 | 5 |
| 2025 | 2 |
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\", '02062000'))
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", '02062000')) 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 CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…NTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.NTSB WPR12LA441Accident · Minor injuriesLimited investigationFinal reportTeam MINI-MAX · Chula Vista, CAA complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…NTSB CEN12FA654Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Roanoke, TXThe loss of engine power during takeoff due to fuel contamination. Contributing to the accident was maintenance personnel's failure to adequately correct the water contamination effects. Contributing to the severity of the occupants' injuries was the lack of…NTSB ERA12FA563Accident · 1 fatalField investigationFinal reportAerospatiale AS 355F1 · West Windsor, NJDisconnection of the upper rod end from the fore/aft servo due to severely worn threads, which resulted in a loss of control and separation of a main rotor blade during cruise flight. Contributing to the accident were incorrect maintenance procedures and…NTSB CEN12LA530Accident · Serious injuriesLimited investigationFinal reportWilliams John T-51 Mustang · Oshkosh, WIThe separation of an engine cooling hose from the radiator.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB CEN12LA348Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Bangor, MIThe pilot’s failure to properly service the fuel system, and subsequent decision to conduct the flight with known fuel system deficiencies, which led to the total loss of engine power.NTSB ERA12LA373Accident · Minor injuriesLimited investigationFinal reportFaltin John R Rotorway Exec 162F · Smoketown, PAA loss of control during a post-maintenance test flight due to improper tracking of the helicopter’s main rotor blades by the pilot/aircraft builder.NTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB WPR12LA217Accident · Serious injuriesLimited investigationFinal reportJackson TOP DOG · Apple Valley, CAA loss of engine power during the initial climb for reasons that could not be determined because the anomalies revealed during the postaccident examination would not have necessarily precluded normal operation. Contributing to the accident was the inadequate…NTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.