NTSB investigations, KS
6 cases where NTSB found Engine fuel and control.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2021 | 2 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010573'))
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" = 'KS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010573')) 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 CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…NTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…NTSB CEN14LA461Accident · No injuriesLimited investigationFinal reportCessna 310K · El Dorado, KSA fatigue failure of the left engine’s throttle cable, which resulted in the loss of left engine power.NTSB CEN12LA288Accident · No injuriesLimited investigationFinal reportDonald K Stovall Pietenpol Aircamper · Rose Hill, KSThe loss of engine power due to carburetor icing.NTSB DEN08FA114Accident · 2 fatalField investigationFinal reportAero Commander 500S · Linwood, KSThe pilot-in-training inadvertently shutting off both engine fuel control valves causing a loss of power in both engines, and the pilot's failure to maintain control of the airplane resulting in a stall. Contributing to the accident was the chief pilot's…