NTSB investigations: Cessna 170A, FL
16 cases on aircraft the registry lists as Cessna 170A. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 2 |
| 1974 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2015 | 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\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304'))
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" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304'))
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 GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.NTSB MIA06CA082Accident · No injuriesData collectionFinal reportCessna C170A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB MIA03FA054Accident · Serious injuriesField investigationFinal reportCessna 170A · Davie, FLThe pilot's improper preflight planning and his inadequate in-flight planning decision which resulted in loss of engine power due to fuel exhaustion and collision with wires and a road during the subsequent forced landing.NTSB MIA98FA064Accident · 1 fatalField investigationFinal reportCessna 170A · Miami, FLfailure of the pilot to maintain adequate airspeed during a banner pickup, which resulted in an inadvertent stall and collision with the terrain. The lack of altitude for a stall recovery was a related factor.NTSB MIA94LA133Accident · No injuriesLimited investigationFinal reportCessna 170A · Boca Raton, FLThe failure of the pilot to maintain directional control.NTSB MIA94LA127Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Bushnell, FLThe pilot-in-command's improper landing flare during a forced landing, resulting in a hard landing and separation of the right main landing gear. Contributing to the accident was a partial loss of engine power due to a loose exhaust valve seat on the No. 3…NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB MIA87LA110Accident · No injuriesLimited investigationFinal reportCessna 170A · Brandon, FLUpon touchdown the right landing gear separated from the acft due to a hard landing.NTSB MIA74DKT84Accident · No injuriesClosedCessna 170A · Naples, FLNTSB MIA69D0092Accident · No injuriesClosedCessna 170 · West Palm Bch, FLNTSB MIA69F0071Accident · Minor injuriesClosedCessna 170 · Deland, FLNTSB MIA68D0311Accident · No injuriesClosedCessna 170A · Tampa, FLNTSB MIA68D0246Accident · No injuriesClosedCessna 170 · Kissimmee, FLNTSB MIA67D0357Accident · No injuriesClosedCessna 170A · Cocoa, FLNTSB MIA66F0135Accident · Minor injuriesClosedCessna 170A · Titusville, FL