NTSB investigations, MN
5 cases where NTSB found Fuel control/carburetor.
Cases per year
| 2013 | 1 |
|---|---|
| 2014 | 1 |
| 2016 | 1 |
| 2024 | 1 |
| 2026 | 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\" = 'MN' 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\", '01057322'))
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" = 'MN' 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", '01057322')) 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 CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.NTSB CEN24LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Duluth, MNThe failure of the left engine induction coupling during takeoff, which resulted in a total loss of left engine power and an uncommanded left yaw/roll due to asymmetrical thrust and increased drag, from which the pilot had insufficient altitude to recover…NTSB CEN16LA287Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Dodge Center, MNA partial loss of engine power due to carburetor ice.NTSB CEN14LA417Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Bruno, MNThe total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.