NTSB investigations: Continental C90 series, ME
25 cases on aircraft whose registry engine model is Continental C90 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1980 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2012 | 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\" = 'ME' 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 ('17009'))
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" = 'ME' 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 ('17009'))
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 ERA23LA226Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8F · Frenchville, METhe pilot's failure to maintain control of the airplane while landing in gusting wind conditions.NTSB ERA12CA499Accident · No injuriesData collectionFinal reportAeronca 7CCM · Norridgewock, METhe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA10CA469Accident · Serious injuriesData collectionFinal reportCessna 140 · Levant, METhe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB NYC06LA070Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Dover-Foxcroft, METhe pilot's inadequate preflight inspection, which failed to detect ice in the fuel system, resulting in a loss of engine power during takeoff-initial climb, and an in-flight collision with trees.NTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.NTSB IAD02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-11S · Palermo, MEpilot's failure to maintain directional control and his inadequate compensation for wind. A factor was the crosswind.NTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.NTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB NYC90LA113Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rumford, METhe pilot made a steep turn to avoid the shore line and inadvertently stalled. Factors related to the accident were: the pilots decision to takeoff with a canoe strapped to one of the floats and his lack of experience in carrying a canoe on the floats.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB NYC85LA218Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Millinocket, METhe plt reported that he was departing from south twin lake in winds that were from 270 deg at 12 gusting 20 KTS. After the acft lifted off the water, he started a slight turn. He stated that at about that time, a gust of wind simultaneously lifted the nose &…NTSB NYC85LA010Accident · No injuriesLimited investigationFinal reportBellanca 7EC · Machias, MEAbout 30 min into the flt the plt noticed a higher than normal engine oil temp. Shortly thereafter the engine lost pwr. During the forced landing in a river bed the acft collided with large boulders.NTSB NYC82FNC04Accident · 1 fatalFinal reportAeronca 7EC · New Gloucester, METhe pilot flew the ski equipped aircraft to a frozen lake where he met two friends who were ice fishing. Later, after he visited with his friends and had given each of them a ride in the aircraft, the pilot took off again. After takeoff, the pilot turned back…NTSB NYC80FNC28Accident · No injuriesClosedEea Biplane A · E Brownfield, MENTSB NYC80FA021Accident · 2 fatalClosedPiper PA-18 · East Machias, MENTSB NYC79DNC38Accident · No injuriesClosedPiper PA-18 · Spruce Head, MENTSB NYC79FNC27Accident · Serious injuriesClosedAeronca 7CCM · Patten, MENTSB NYC77FNC45Accident · No injuriesClosedCessna 120 · Limerick, MENTSB NYC76FNC67Accident · No injuriesClosedPiper PA-11 · Cushing, MENTSB NYC73DNC42Accident · No injuriesClosedLuscombe 8F · Turner, MENTSB NYC72FNC04Accident · Minor injuriesClosedPiper PA-18S · Auburn, MENTSB NYC71FFG04Accident · No injuriesClosedCessna 140 · Norridgewock, MENTSB NYC69F0386Accident · No injuriesClosedCessna 140 · Biddeford, MENTSB NYC69D0108Accident · Minor injuriesClosedCessna 120 · Turner, ME