NTSB investigations: Continental C145 series
19 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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\" = 220))
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" = 220))
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 SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.NTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.NTSB ANC01LA127Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Chickaloon, AKThe pilot's delay in aborting the takeoff. Factors in the accident were the presence of trees at the end of the departure path, and the pilot's improper use of the carburetor heat control.NTSB FTW00LA229Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Pettigrew, ARthe pilot's failure to maintain obstacle clearance during landing.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 FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB ANC97LA154Accident · No injuriesLimited investigationFinal reportCessna 170B · Lime Village, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.NTSB ANC90LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Sulatna Cross, AKThe pilot failed to adequately assess the existing snow conditions and surrounding terrain (preflight planning) prior to takeoff. Contributing factors were: the lighting conditions, the pilot's over confidence in the airplane's performance capabilities and…NTSB ATL89LA136Accident · No injuriesLimited investigationFinal reportCessna 170 · Orwell, OHThe pilot's decision to takeoff on unsuitable terrain, which resulted in his inability to attain sufficient airspeed to clear the fence(s) near the end of the runway. Factors related to the accident were: the soft runway/terrain conditions & the fence.NTSB ANC86LA005Accident · No injuriesLimited investigationFinal reportCessna 170B · Tok, AKThe plt elected to land on an airstrip next to the alaskan highway. He stated that there was brush along the edge of the strip which was 'grown in' & was higher than he had realized. During the landing, the acft bounced, then the left wing hit a small tree…NTSB LAX85LA085Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Cottonwood, AZWitnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wiresNTSB ANC83LA015Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Elim, AKAccording to a witness, the acft lifted off the rwy about midfield, climbed to about 30-50 ft AGL & then began a dive. The witness heard no change in eng sound. The acft's wing first struck a box set on top of other equipment on the ground(about 4 ft 6 in…