Skip to content

NTSB investigations: Lycoming 0-290 series, GA

21 cases on aircraft whose registry engine model is Lycoming 0-290 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" = 'GA' 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 ('41506')) 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\" = 'GA' 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 ('41506'))
  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" = 'GA' 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 ('41506'))
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 ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.Sep 25, 2021 · N5656H · Substantial damage NTSB ERA21LA038Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA22 · Warner Robins, GAThe pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.Nov 1, 2020 · N3225B · Substantial damage NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.Apr 28, 2005 · N7053K · Substantial damage NTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.Mar 29, 1998 · N1846A · Substantial damage NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.Jun 30, 1996 · N7685K · Substantial damage NTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…May 1, 1996 · N1209C · Substantial damage NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).Nov 18, 1994 · N5418H · Destroyed NTSB ATL89FA144Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Augusta, GAFailure of the pilot to maintain adequate airspeed, while making a steep turn after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.May 6, 1989 · N8693C · Substantial damage NTSB ATL86LA145Accident · Minor injuriesLimited investigationFinal reportLangeford Midget Mustang MM-1 · Fayetteville, GAThe plt had flown the acft for about 20 minutes in the local area after which he returned to the airfield and made an apch. He initiated a go-around and reached about 400 ft AGL when the eng quit. He made a forced landing in a field and the acft nosed over.…May 24, 1986 · N8276 · Substantial damage NTSB ATL81FKG28Accident · No injuriesClosedPiper PA-18 · Carrollton, GAJun 20, 1981 · N5589J · Substantial damage NTSB MIA78FKG66Accident · No injuriesClosedPiper PA-20 · Millen, GAJul 23, 1978 · N1145C · Substantial damage NTSB MIA77FK648Accident · No injuriesClosedChampion 7HC · Savannah, GAJul 9, 1977 · N8576E · Substantial damage NTSB MIA77FKG20Accident · No injuriesClosedChampion 7HC · Vidalia, GAFeb 8, 1977 · N8902R · Substantial damage NTSB MIA76DKG22Accident · Minor injuriesClosedPiper PA-22 · Claxton, GASep 1, 1975 · N3346B · Substantial damage NTSB MIA73FKG56Accident · Serious injuriesClosedPiper PA-22 · Peachtree City, GADec 29, 1972 · N3649A · Substantial damage NTSB MIA73DKG55Accident · Minor injuriesClosedSidewinder Smith · Milledgeville, GADec 28, 1972 · N2285 · Substantial damage NTSB MIA73DKG04Accident · No injuriesClosedPiper PA-18 · Adairsville, GAJul 2, 1972 · N234T · Substantial damage NTSB MIA72FKG55Accident · Minor injuriesClosedPiper PA-22 · Wrens, GANov 14, 1971 · N884A · Substantial damage NTSB MIA68F0250Accident · No injuriesClosedPiper PA-18 · Marietta, GASep 9, 1967 · N168T · Substantial damage NTSB MIA66D0586Accident · No injuriesClosedPiper PA-22 · Sylvester, GAMay 22, 1966 · N3341A · Substantial damage NTSB UNK64X3594Accident · Serious injuriesClosedPiper J3 · Senoia, GAAug 25, 1964 · N2220M · Destroyed