NTSB investigations: Continental C145 series, MO
16 cases on aircraft whose registry engine model is Continental C145 series. 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 | 2 |
| 1967 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 2002 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2021 | 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\" = 'MO' 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'))
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" = 'MO' 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'))
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 CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.NTSB CHI02LA096Accident · No injuriesLimited investigationFinal reportCessna 170A · Gainesville, MOThe pilot's misjudgment of distance/altitude and his failure to perform a go-around.NTSB MKC88LA094Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Cassville, MOThe PIC dptd Texas enr to bolivar, MO with a stop for fuel in pinebluff, ark with two revenue pax's aboard. The PIC stated that the pax would try to locate the arpt by visually identifying the lights of the city. The PIC stated they wandered to several…NTSB MKC85LA027Accident · No injuriesLimited investigationFinal reportTemco GC-1B Swift · Fulton, MOThe acft left the rwy collided with a pile of brush and nosed over during takeoff. A x-wind of 90 degrees at 8-14 KTS affected the takeoff. The plt said he delayed the abort too long after the acft started heading off the rwy thinking he could become airborne.NTSB MKC80FCG40Accident · No injuriesClosedCessna 170 · Lake Winnebago, MONTSB MKC79FCG26Accident · No injuriesClosedCessna 170 · Waldron, MONTSB MKC78DCG68Accident · No injuriesClosedCessna 170B · Grain Valley, MONTSB MKC76DCG59Accident · No injuriesClosedCessna 170B · Lake Winnebago, MONTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MONTSB MKC68F0349Accident · Minor injuriesClosedCessna 170B · Salem, MONTSB MKC68F0406Accident · No injuriesClosedCessna 170 · Eldon, MONTSB MKC67F0288Accident · No injuriesClosedCessna 170 · Ft.L.Wood, MONTSB MKC66D0399Accident · No injuriesClosedCessna 170B · Kansas City, MONTSB MKC66D0280Accident · No injuriesClosedCessna 170B · Wheton, MO