NTSB investigations: Cessna 170B
7 cases on aircraft the registry lists as Cessna 170B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2004 | 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 ('2072306', '2072307')
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\" = 351))
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 ('2072306', '2072307')
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" = 351))
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 LAX04LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Santa Rosa, CAthe failure of the number 2 cylinder barrel due to fatigue. The lack of suitable landing terrain was a factor in the accident.NTSB ANC98LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKA failure of the number six cylinder rod bearing and connecting rod cap for undetermined reasons. Factors in the accident were snow covered terrain that was unsuitable for a forced landing.NTSB LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.NTSB ANC95LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Chickaloon, AKThe fracture of the crankshaft resulting in separation of the propeller and propeller flange in-flight. A factor associated with the accident was the lack of suitable terrain for an emergency landing.NTSB ANC90LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKA power loss due to a fatigue failure of the #5 exhaust rocker arm.NTSB ANC87LA066Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe pilot stated during a low level flight above the trees, the aircraft started to vibrate. A few seconds later the propeller completely separated from the aircraft. The propeller was not located in the wooded area. The propeller separated from the aircraft…NTSB ANC86LA103Accident · No injuriesLimited investigationFinal reportCessna 170B · Tekanika River, AKThe acft nosed over during the forced landing which followed a total loss of pwr. The plt reported he noted a decrease in oil pressure during cruise flt just prior to the pwr loss. Examination of the acft eng revealed that the #6 cylinder push rod had failed.