NTSB investigations: Continental C145 series, UT
21 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 |
| 1969 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2010 | 2 |
| 2017 | 1 |
| 2022 | 1 |
| 2023 | 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\" = 'UT' 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" = 'UT' 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 WPR23LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fremont Island, UTThe pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.NTSB WPR23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Monument Valley, UTThe pilot’s loss of airplane control during the landing flare in gusting wind and subsequent loss of directional control during the landing roll.NTSB GAA17CA468Accident · Serious injuriesData collectionFinal reportCessna 170 · Moab, UTThe pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.NTSB WPR10CA394Accident · Minor injuriesData collectionFinal reportCessna 170 · Salt Lake City, UTThe pilot’s failure to maintain aircraft control during the landing roll.NTSB WPR10CA243Accident · No injuriesData collectionFinal reportCessna 170B · Moab, UTThe pilot's failure to maintain directional control during the landing roll.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.NTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).NTSB FTW98LA237Accident · No injuriesLimited investigationFinal reportCessna 170A · Provo, UTfailure of the pilot to maintain directional control of the airplane. A related factor was the right quartering tailwind gust.NTSB DEN90FA155Accident · Serious injuriesField investigationFinal reportCessna 170 · Fillmore, UTThe pilot's failure to maintain airspeed which resulted in inadvertent stall.NTSB DEN90LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Salina, UTPower loss as a result of water contaminated fuel. Contributing to the accident were: an inadequate preflight inspection by the pilot, and rough terrain encountered during the ground run, following the forced landing.NTSB DEN88LA175Accident · No injuriesLimited investigationFinal reportBraswell Scirroco MJ5-K2 · Hurricane, UTThe plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA…NTSB DEN87LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Monument Valley, UTThe plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction.NTSB DEN86LA111Accident · No injuriesLimited investigationFinal reportCessna 170B · St George, UTThe plt stated the acft encountered a crosswind and ground looped during the landing touchdown.NTSB DEN81DTM33Accident · No injuriesClosedCessna 170B · St George, UTNTSB DEN75DTM07Accident · No injuriesClosedCessna 170B · Morgan, UTNTSB DEN72DTM13Accident · No injuriesClosedCessna 170B · Monticello, UTNTSB DEN70D0110Accident · No injuriesClosedCessna 170A · Sandy, UTNTSB DEN67D0043Accident · No injuriesClosedCessna 170 · Moab, UTNTSB DEN66F0339Accident · No injuriesClosedCessna 170 · Oljato, UTNTSB DEN65F0024Accident · Minor injuriesClosedCessna 170A · Huntington, UT