NTSB investigations: Cessna 170B, PA
15 cases on aircraft the registry lists as Cessna 170B. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1991 | 1 |
| 2018 | 1 |
| 2020 | 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\" = 'PA' 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 ('2072306', '2072307'))
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" = 'PA' 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 ('2072306', '2072307'))
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 ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB NYC91LA244Accident · Serious injuriesLimited investigationFinal reportCessna 170B · E. Stroudsbury, PAImproper takeoff planning by the pilot which resulted in the airplane striking trees during initial climb. A factor related to the accident was the failure of the pilot to make his departure turn in a timely manner.NTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PANTSB NYC76FHA02Accident · Serious injuriesClosedCessna 170B · Analomink, PANTSB NYC75DHA36Accident · No injuriesClosedCessna 170B · Hazleton, PANTSB NYC75DHA16Accident · No injuriesClosedCessna 170B · E Stroudsburg, PANTSB NYC74FGT21Accident · No injuriesClosedCessna 170B · Hanover, PANTSB NYC73FHA04Accident · No injuriesClosedCessna 170 · Montrose, PANTSB NYC72AN022Accident · 1 fatalClosedCessna 170B · Wellsboro, PANTSB NYC70FGM10Accident · Serious injuriesClosedCessna 170B · W.Fairfield, PANTSB NYC69F0126Accident · No injuriesClosedCessna 170B · Monroeville, PANTSB NYC66D0651Accident · No injuriesClosedCessna 170B · Montgomery, PANTSB NYC65F0213Accident · No injuriesClosedCessna 170 · Elizabethville, PANTSB UNK64X4057Accident · 3 fatalClosedCessna 170B · Ickesburg, PA