NTSB investigations: Cessna 170B, LA
7 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 |
| 1970 | 1 |
| 1971 | 2 |
| 1982 | 1 |
| 1985 | 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\" = 'LA' 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" = 'LA' 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 FTW85LA201Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ama, LAThe aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used…NTSB FTW82FRJ11Accident · Serious injuriesFinal reportCessna 170B · Plain Dealing, LAThe aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while…NTSB FTW72DRJ17Accident · No injuriesClosedCessna 170B · Robson, LANTSB FTW72DRJ16Accident · No injuriesClosedCessna 170B · Tallulah, LANTSB FTW70DRJ10Accident · No injuriesClosedCessna 170B · Alexandria, LANTSB FTW66D0175Accident · No injuriesClosedCessna 170A · Jonesville, LANTSB UNK64X0657Accident · No injuriesClosedCessna 170B · Cut Off, LA