NTSB investigations: Continental C145 series, MN
4 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “Loss of control - on ground/water”. 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 |
|---|---|
| 1987 | 3 |
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\" = 'MN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012')
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\" = 260))
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" = 'MN' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012')
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" = 260))
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 CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…NTSB CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…NTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…