NTSB investigations: Continental C145 series
19 cases on aircraft whose registry engine model is Continental C145 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 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\" = 353))
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" = 353))
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 ANC07FA037Accident · 1 fatalField investigationFinal reportCessna 170 · Wasilla, AKA total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB CHI06CA167Accident · Minor injuriesData collectionFinal reportCessna 170A · Atwood, ILThe loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB MIA03FA054Accident · Serious injuriesField investigationFinal reportCessna 170A · Davie, FLThe pilot's improper preflight planning and his inadequate in-flight planning decision which resulted in loss of engine power due to fuel exhaustion and collision with wires and a road during the subsequent forced landing.NTSB IAD02LA034Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Fredericksburg, VAThe unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.NTSB ANC98LA081Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Homer, AKThe loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…NTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.NTSB ANC91LA012Accident · No injuriesLimited investigationFinal reportCessna 170A · Healy, AKThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.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 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.NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.NTSB ANC89LA053Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Fairbanks, AKThe student pilot's inproper use of carburetor heat and the instructors failure to properly supervise the student actions within the airplane.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 CHI87LA189Accident · No injuriesLimited investigationFinal reportAeronca 15AC · St Bonifacius, MNThe plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn…NTSB ANC86LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe plt reported experiencing a total loss of pwr during cruise flt. He stated he switched fuel tanks and was temporarily able to regain pwr before experiencing a second total loss. Substantial damage resulted during the forced landing. During post accident…NTSB DEN85LA181Accident · No injuriesLimited investigationFinal reportCessna 170B · Swan Lake, MTThe plt said that prior to departure there was an estimated 14 gals of fuel on board. After aprx 30 minutes of flight the eng lost all pwr and a forced landing was accomplished in a mountainous creek bed. During the landing roll the acft struck a feeled tree…NTSB FTW83LA233Accident · No injuriesLimited investigationFinal reportCessna 170A · Prague, OKWhile turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…NTSB LAX83LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Pleasonton, CAThe acft collided with a street curb during an off airport forced landing. The pilot stated that during climb-out at 3000 feet the engine RPM began to decrease. He used carburetor heat as the engine lost power to 1000 RPM. He also switched tanks from both to…NTSB CHI83LA032Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Boston Heights, OHThe pilot reported that the engine lost power abruptly as he was climbing through about 200 ft AGL after takeoff. During a forced landing, he maneuvered to avoid houses and attempted to land between two trees. Reportedly, the aircraft collided with a tree and…