NTSB investigations: Continental C145 series
12 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “In flight encounter with weather”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2007 | 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.\"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\" = 240))
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."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" = 240))
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 ANC08CA020Accident · No injuriesData collectionFinal reportCessna 170B · Nikolai, AKThe pilot's continued flight into adverse weather (icing conditions), which resulted in a loss of engine power during a go-around. Factors contributing to the accident were icing conditions, and carburetor/induction icing.NTSB ANC01LA065Accident · No injuriesLimited investigationFinal reportCessna 170B · Sand Point, AKThe pilot's inadequate compensation for wind conditions while on approach, and the inadvertent stall of the airplane while attempting a go-around. A factor associated with the accident was a crosswind.NTSB ANC98LA113Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kodiak, AKThe pilot's inadequate weather evaluation and compensation for wind conditions. Factors associated with the accident are wind gusts, a sudden windshift to a tailwind, the pilot's failure to abort the takeoff, and an inadvertent stall/mush.NTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.NTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.NTSB LAX91LA406Accident · Serious injuriesLimited investigationFinal reportCallair A-3 · Williams, AZThe pilot's encounter with a strong and gusty cross-wind which suddenly developed in the area and his subsequent loss of control. Factors which contributed to the accident were the pilot's inadequate airspeed and inability to adequately compensate for the…NTSB ANC91LA089Accident · No injuriesLimited investigationFinal reportCessna 170B · Prospect Creek, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his delay in reversing course (remedial action). The terrain and weather conditions were related factors.NTSB LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.NTSB ANC87LA121Accident · No injuriesLimited investigationFinal reportCessna 170 · Mi.70 Glenn Hwy, AKThe pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the…NTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.NTSB LAX83LA306Accident · Serious injuriesLimited investigationFinal reportCessna C170A · Cajon Pass, CAThe plt was flying about 40 ft AGL in marginal weather when the acft contacted a power line and crashed. No flt plan wasfiled and there is no record of a weather briefing for the plt. The plt stated he was following a highway up a Pass whenhe encountered…NTSB LAX83FA153Accident · 2 fatalField investigationFinal reportCessna 170B · Near Pala, CAAccording to a friend of the plt, he (the plt) had watched wx infor on tv, on 3/20/83. To the friend's knowledge, the plt had never telephoned the FAA fss for a wx briefing or to file a flt plan. After the friend took the plt & his wife (who was also a plt)…