Skip to content

NTSB investigations: Continental C145 series, WI

24 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'WI' 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

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\" = 'WI' 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" = 'WI' 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

Run 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 CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.Oct 25, 1995 · N4555C · Substantial damage NTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.Feb 19, 1994 · N4685C · Substantial damage NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.Jun 11, 1993 · N1932C · Substantial damage NTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.Mar 3, 1991 · N1340H · No damage NTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.Jul 30, 1990 · N66BR · 2 aircraft · Substantial damage NTSB CHI89LA159Accident · No injuriesLimited investigationFinal reportCessna 170A · Brookfield, WIThe pilot-in-command's failure to take proper corrective action after encountering a wind gust on landing.Aug 4, 1989 · N9762A · Substantial damage NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.Jul 3, 1989 · N1271H · Substantial damage NTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.Apr 2, 1989 · N3016A · Substantial damage NTSB CHI84LA285Accident · No injuriesLimited investigationFinal reportCessna 170B · Edgerton, WIThe plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn…Jul 10, 1984 · N2748C · Substantial damage NTSB CHI80DEP57Accident · No injuriesClosedCessna 170A · Iola, WISep 21, 1980 · N401P · Substantial damage NTSB CHI77DER01Accident · No injuriesClosedCessna 170B · Rice Lake, WIJan 23, 1977 · N1782D · Substantial damage NTSB CHI76DEP27Accident · No injuriesClosedCessna 170A · Hartford, WIApr 3, 1976 · N1332D · Substantial damage NTSB CHI75FEP70Accident · No injuriesClosedCessna 170B · Medford, WIJun 19, 1975 · N2352D · Substantial damage NTSB CHI75FEP36Accident · No injuriesClosedCessna 170B · Waukesha, WIDec 28, 1974 · N3120B · Substantial damage NTSB CHI74FER05Accident · No injuriesClosedCessna 170A · Horse Creek, WIJun 30, 1974 · N9546A · Substantial damage NTSB CHI74DEP46Accident · No injuriesClosedAeronca 15AC · St Germain, WIMay 26, 1974 · N1083H · Substantial damage NTSB CHI74DEP43Accident · No injuriesClosedCessna 170A · Gratiot, WIApr 21, 1974 · N5781C · Substantial damage NTSB CHI67D0436Accident · No injuriesClosedAeronca 15AC · Pt.Washington, WIDec 18, 1966 · N1401H · Substantial damage NTSB CHI67F0354Accident · No injuriesClosedCessna 170B · Pewaukee, WINov 20, 1966 · N3120B · Substantial damage NTSB CHI67F0191Accident · Minor injuriesClosedAeronca 15AC · Superior, WISep 6, 1966 · N1156H · Substantial damage NTSB CHI67F0122Accident · No injuriesClosedCessna 170B · Brookfield, WIJul 29, 1966 · N3194B · Substantial damage NTSB CHI66D0577Accident · No injuriesClosedCessna 170B · Depere, WIJan 29, 1966 · N8084A · Substantial damage NTSB CHI65F0032Accident · No injuriesClosedCessna 170B · Wausau, WIFeb 10, 1965 · N4550C · Substantial damage NTSB UNK64X0106Accident · No injuriesClosedCessna 170B · Superior, WIJan 1, 1964 · N2797D · Substantial damage