Skip to content

NTSB investigations: Continental 0-300 series, ME

26 cases on aircraft whose registry engine model is Continental 0-300 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" = '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 ('17022')) 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\" = '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 ('17022'))
  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 ('17022'))
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 ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.Sep 1, 2025 · N3576D · Substantial damage NTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.Mar 2, 2017 · N7450X · Substantial damage NTSB GAA17CA036Accident · No injuriesData collectionFinal reportCessna 172 · Carrabassett, METhe pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.Oct 20, 2016 · N1706F · Substantial damage NTSB ERA13FA388Accident · 1 fatalField investigationFinal reportCessna 172 · Limington, MEAn impairing medical event of undetermined origin that led to a loss of control during takeoff.Aug 30, 2013 · N8063B · Substantial damage NTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.Aug 9, 2012 · N9838M · Substantial damage NTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.Jul 3, 2009 · N1782F · Substantial damage NTSB ERA09CA309Accident · No injuriesData collectionFinal reportCessna 172A · Glenburn, METhe pilot's misjudgment of distance and speed during landing.May 26, 2009 · N6843X · Substantial damage NTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.Aug 27, 2005 · N1680Y · Substantial damage NTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.Aug 5, 2005 · N5924R · Substantial damage NTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.Aug 14, 2002 · N56BC · Substantial damage NTSB IAD02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Phillips, MELoss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall.Oct 4, 2001 · N7591X · Substantial damage NTSB NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…Aug 25, 1984 · N5091A · Destroyed NTSB NYC83FA260Accident · 3 fatalField investigationFinal reportCessna 170B · Livermore Falls, METhe acft collided with trees during a go-around at night in a ground fog. The plt had called his wife and discussed the weather. He decided on an alternate arpt if the weather created problems. He had flown into bowman field many times at night and knew the…Oct 1, 1983 · N2429D · Destroyed NTSB NYC83IA013Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Augusta, METhe student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…Oct 25, 1982 · N25973 · 2 aircraft · Minor damage NTSB NYC79DNC50Accident · No injuriesClosedCessna 172 · Brewer, MESep 12, 1979 · N6754A · Substantial damage NTSB NYC78DNC12Accident · No injuriesClosedCessna 172 · Wayne, MEJan 28, 1978 · N8818B · Substantial damage NTSB NYC73DNC37Incident · Minor injuriesClosedCessna 172 · Waterville, MEOct 27, 1972 · N1747F · Minor damage NTSB NYC69D0315Accident · No injuriesClosedCessna 170 · Burlington, MEFeb 1, 1969 · N3532D · Substantial damage NTSB NYC69D0031Accident · No injuriesClosedCessna 172 · Meddybemps, MEJun 16, 1968 · N8549U · Substantial damage NTSB NYC68D0077Accident · Minor injuriesClosedCessna 172 · Millinocket, MEJul 14, 1967 · N3861L · Substantial damage NTSB NYC68D0016Accident · Minor injuriesClosedCessna 172G · Sherman, MEJun 13, 1967 · N3653L · Substantial damage NTSB NYC67F0671Accident · No injuriesClosedCessna 172 · Caribou, MEMay 27, 1967 · N3738S · Substantial damage NTSB NYC67D0243Accident · No injuriesClosedCessna 172 · Sunset, MEAug 31, 1966 · N4213L · Substantial damage NTSB NYC66F0427Accident · No injuriesClosedCessna 172 · Lewiston, MEDec 23, 1965 · N8197B · Substantial damage NTSB UNK65X0485Accident · No injuriesClosedCessna 172E · Lubec, MEOct 30, 1964 · N5561T · Substantial damage NTSB UNK64X2898Accident · No injuriesClosedCessna 170B · Isleboro, MEJul 18, 1964 · N3500C · Substantial damage