NTSB investigations, AR
12 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2009 | 2 |
|---|---|
| 2011 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.NTSB CEN19LA146Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Morrilton, ARThe improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.NTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…NTSB CEN16LA026Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · Fayetteville, ARThe fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power.NTSB CEN15LA270Accident · No injuriesLimited investigationFinal reportPiper PA28-200 · Jonesboro, ARMaintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.NTSB CEN15LA233Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Piggott, ARThe loss of engine power due to a malfunctioning magneto. Contributing to the accident was maintenance personnel's improper use of a drill bit instead of a timing pin during magneto installation, which resulted in a section of the drill bit breaking off and…NTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.NTSB CEN11LA460Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Pine Bluff, ARThe use of an incorrect mounting bolt by maintenance persons to attach the engine torque sensor, which resulted in an internal failure of the torque sensor and subsequent loss of engine power due to fuel starvation.NTSB CEN11LA404Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Athleimer, ARFailure of the first stage planetary gearset in the propeller reduction gearbox, which resulted in catastrophic engine failure. Contributing to the failure was the misrepresentation of the gearset being zero-timed by the company that sold the gearset to the…NTSB CEN09LA401Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Knobel, ARThe failure of the P-3 tube resulting in the loss of engine power.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.