NTSB investigations: Cessna 170
7 cases on aircraft the registry lists as Cessna 170, where the first occurrence was “Loss of engine power(total) - nonmechanical”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ANC07FA037Accident · 1 fatalField investigationFinal reportCessna 170 · Wasilla, AKA total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB IAD02LA034Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Fredericksburg, VAThe unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.NTSB MIA02LA006Accident · No injuriesLimited investigationFinal reportCessna 170 · Bennettsville, SCThe blockage of the fuel vent and also the collapsed fuel supply line resulting in the total loss of engine power due to fuel starvation.NTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.NTSB MKC88LA094Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Cassville, MOThe PIC dptd Texas enr to bolivar, MO with a stop for fuel in pinebluff, ark with two revenue pax's aboard. The PIC stated that the pax would try to locate the arpt by visually identifying the lights of the city. The PIC stated they wandered to several…NTSB LAX83LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Pleasonton, CAThe acft collided with a street curb during an off airport forced landing. The pilot stated that during climb-out at 3000 feet the engine RPM began to decrease. He used carburetor heat as the engine lost power to 1000 RPM. He also switched tanks from both to…