Skip to content

NTSB investigations: Lycoming 0-320 series, ME

92 cases on aircraft whose registry engine model is Lycoming 0-320 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, newest first

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 ('41508')) 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 ('41508'))
  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 ('41508'))
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 NYC86LA226Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · So. Berwick, METhe acft experienced a loss of eng power while leveling off at 2,500 ft MSL shortly after takeoff. Remedial action was attempted, however, power was not regained. The plt initiated a 180 deg turn back toward the arpt but altitude was insufficient to reach the…Sep 1, 1986 · N26784 · Substantial damage NTSB NYC86LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hampden, MEAfter taking off, the plt initiated a climb & leveled off at 2500'. As he reduced power to cruise, the eng stopped running. All attempts to restart the eng were unsuccessful. Subsequently, the acft was damaged when the plt landed on rocky pasture land. Fuel…Apr 15, 1986 · N6264W · Substantial damage NTSB NYC84LA253Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seboomook Lake, METhe acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated…Jul 21, 1984 · N9276D · Substantial damage NTSB NYC83LA119Accident · No injuriesLimited investigationFinal reportBeech Sport · Bangor, METhe acft ran off the runway and collapsed the landing gear during landing. The student pilot had made 7 successful landings. On this final landing a gust of wind blew the acft across the runway and the pilot lost direction control. The acft went off the left…May 19, 1983 · N24687 · Destroyed NTSB NYC82DA225Accident · No injuriesFinal reportCessna 172K · Vinalhaven, METhe engine lost power at 100 feet of altitude after takeoff. The pilot found by pumping the throttle, he could regain some power. The aircraft collided with trees and came to rest on the ground. The mixture control cable had separated about one inch from it…Sep 11, 1982 · N84220 · Destroyed NTSB NYC82DA185Accident · No injuriesFinal reportGrumman AA-5A · Wiscasset, METhe student pilot was making an approach and was low and slow. By the time the instructor took over the aircraft the recovery was slow and the aircraft touched down in rough terrain 500 feet short of the runway. The nose gear snapped offduring landing.Aug 7, 1982 · N8476B · Substantial damage NTSB NYC81FNC18Accident · No injuriesClosedCessna 172 · Kittery, MEAug 3, 1981 · N734QZ · Substantial damage NTSB NYC81FNC07Accident · Minor injuriesClosedCessna 172 · Wiscasset, MEJan 10, 1981 · N2466E · Substantial damage NTSB NYC80FNC33Accident · No injuriesClosedCessna 172 · Turner, MEJul 8, 1980 · N9931Q · Substantial damage NTSB NYC80DNC24Accident · No injuriesClosedChampion 7GCB · New Limerick, MEMay 10, 1980 · N9926Y · Substantial damage NTSB NYC80FA060Accident · 2 fatalClosedCessna 172 · Rockland, MEMar 16, 1980 · N707BB · Destroyed NTSB NYC80FNC16Accident · No injuriesClosedPiper PA-28 · Eliot, MEMar 15, 1980 · N57302 · Substantial damage NTSB NYC80FA006Accident · 1 fatalClosedPiper PA-28 · Gilead, MEOct 25, 1979 · N407FL · Substantial damage NTSB NYC79DA096Accident · No injuriesClosedCessna 172 · Greenville, MESep 10, 1979 · N12736 · Substantial damage NTSB NYC79FNC49Accident · Minor injuriesClosedPiper PA-22 · Bangor, MEAug 26, 1979 · N2508P · Substantial damage NTSB NYC79DNC39Accident · No injuriesClosedPiper PA-18S · Jackson, MEJul 10, 1979 · N9276D · Substantial damage NTSB NYC78FNC51Accident · Serious injuriesClosedCessna 172M · Old Town, MESep 17, 1978 · N9604H · No damage NTSB NYC78DNC49Accident · No injuriesClosedPiper PA-28 · Dexter, MESep 4, 1978 · N6910W · Substantial damage NTSB NYC78DNC29Accident · No injuriesClosedChampion 7ECA · Piscataquis, MEJun 2, 1978 · N6364N · Substantial damage NTSB NYC78DNC11Accident · No injuriesClosedCessna 172M · Harbor, MEDec 19, 1977 · N13144 · Substantial damage NTSB NYC77DNC56Accident · No injuriesClosedCessna 172 · Brunswick, MESep 22, 1977 · N7919G · Substantial damage NTSB NYC77FNC52Accident · No injuriesClosedPiper PA-20 · Thomaston, MEAug 31, 1977 · N7309K · Substantial damage NTSB NYC77DNC49Accident · Minor injuriesClosedCessna 177 · Hope, MEAug 28, 1977 · N3366T · Substantial damage NTSB NYC77FNC43Accident · 1 fatalClosedBellanca 7GCBC · Ft Fairfield, MEAug 2, 1977 · N57482 · Destroyed NTSB NYC77DNC42Accident · No injuriesClosedPiper PA-28 · Old Town, MEJul 22, 1977 · N7882C · Substantial damage NTSB NYC77DNC24Accident · No injuriesClosedBeech B19 · Machias, MEApr 11, 1977 · N24605 · Substantial damage NTSB NYC77DNC18Accident · No injuriesClosedCessna 172 · Abbott Village, MEJan 6, 1977 · N12734 · Substantial damage NTSB NYC76DNC26Accident · No injuriesClosedPiper PA-18 · Brooklin, MEOct 19, 1975 · N7068D · Substantial damage NTSB NYC76DNC21Accident · Minor injuriesClosedPiper PA-18 · Greenville, MESep 25, 1975 · N3690A · Substantial damage NTSB NYC76FNC13Accident · Minor injuriesClosedStinson 10A · Northport, MEAug 21, 1975 · N31586 · Destroyed NTSB NYC75DNC27Accident · No injuriesClosedCessna 172 · Rockland, MEMar 31, 1975 · N8436L · Substantial damage NTSB NYC75AN056Accident · Minor injuriesClosedPiper PA-18 · Patten, MENov 3, 1974 · N3696Z · Substantial damage NTSB NYC72DNC39Accident · No injuriesClosedPiper PA-18 · Clinton, MEMar 30, 1972 · N4275Z · Substantial damage NTSB NYC72DNC08Accident · No injuriesClosedPiper PA-28 · Limestone, MEAug 2, 1971 · N98384 · Substantial damage NTSB NYC71DFG17Accident · No injuriesClosedPiper PA-22 · Caribou, MEMar 10, 1971 · N7304D · Substantial damage NTSB NYC71DFG12Accident · No injuriesClosedPiper PA-28 · Belfast, MEJan 10, 1971 · N8870N · Substantial damage NTSB NYC70D0214Accident · Minor injuriesClosedPiper PA-28 · Pittsfield, MENov 24, 1969 · N7577R · Substantial damage NTSB NYC69D0361Accident · No injuriesClosedCessna 172I · Biddeford, MEMar 15, 1969 · N35501 · Substantial damage NTSB NYC68D0086Accident · Minor injuriesClosedPiper PA-28 · Lincolnville, MEJun 24, 1967 · N5194W · Substantial damage NTSB NYC67F0368Accident · No injuriesClosedPiper PA-24 · Auburn, MEDec 5, 1966 · N7216P · Substantial damage NTSB NYC67F0086Accident · No injuriesClosedPiper PA-28 · Winterport, MEJul 11, 1966 · N6910W · Substantial damage NTSB UNK64X3816Accident · Minor injuriesClosedPiper PA22 · Patten, MESep 6, 1964 · N8858D · Substantial damage