Skip to content

NTSB investigations: Lycoming 0-290 series, NC

31 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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA20CA251Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 22 · Fuquay Varina, NCThe pilot's failure to attain a proper approach speed, which resulted in an overrun of the wet grass runway.Jul 14, 2020 · N1520P · Substantial damage NTSB ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.Aug 16, 2005 · N8595C · Substantial damage NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.Feb 18, 2005 · N1476A · Substantial damage NTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.Jan 30, 2004 · N1107C · Substantial damage NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.Sep 23, 2000 · N3483A · Substantial damage NTSB ATL94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22\20 · Kill Devil Hill, NCThe pilot's failure to adequately compensate for the crosswind condition during a landing rollout.May 29, 1994 · N1665A · Substantial damage NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.Apr 21, 1984 · N8092C · Substantial damage NTSB IAD78DKM26Accident · No injuriesClosedStarduster SA-100 · Franklinville, NCSep 27, 1978 · N33BG · Destroyed NTSB IAD77DLJ13Accident · Minor injuriesClosedPiper PA-12 · Elizabeth City, NCApr 17, 1977 · N21M · Substantial damage NTSB IAD76DKM27Accident · No injuriesClosedPiper PA-22 · Whitsett, NCJan 14, 1976 · N851A · Substantial damage NTSB IAD76FLJ06Accident · 1 fatalClosedPiper PA-18A · Kinston, NCAug 12, 1975 · N3696A · Destroyed NTSB IAD75DLJ20Accident · No injuriesClosedStinson 10A · Lumberton, NCFeb 22, 1975 · N36721 · Substantial damage NTSB IAD74FKM31Accident · No injuriesClosedChampion 7HC · Thomasville, NCDec 23, 1973 · N8555E · Substantial damage NTSB IAD73DKM42Accident · No injuriesClosedBerg-Aero 19181A · Archdale, NCMay 22, 1973 · N2418 · Substantial damage NTSB NYC73FLJ10Accident · No injuriesClosedPiper PA-22 · Maple Hill, NCSep 24, 1972 · N3380B · Substantial damage NTSB IAD71DKM26Accident · No injuriesClosedPiper PA-22 · Statesville, NCJan 31, 1971 · N2643A · Substantial damage NTSB IAD70D0107Accident · No injuriesClosedPiper PA-22 · Vale, NCNov 23, 1969 · N3212B · Substantial damage NTSB IAD70D0055Accident · No injuriesClosedPiper PA-22 · Advance, NCAug 30, 1969 · N891A · Substantial damage NTSB DIA70D0032Accident · No injuriesClosedPiper PA-20 · Advance, NCJul 28, 1969 · N4944M · Substantial damage NTSB DIA68D0145Accident · No injuriesClosedPiper PA-22 · Asheville, NCJan 9, 1968 · N2102A · Substantial damage NTSB DIA68D0121Accident · No injuriesClosedPiper PA-20 · Bat Cave, NCDec 1, 1967 · N7620K · Substantial damage NTSB DIA67F0080Accident · No injuriesClosedPiper PA-20 · Benson, NCApr 21, 1967 · N1508A · Substantial damage NTSB DIA67F0050Accident · No injuriesClosedPiper PA-22 · Charlotte, NCMar 15, 1967 · N2244A · Substantial damage NTSB MIA66F0546Accident · No injuriesClosedPiper PA-22 · Trinity, NCMay 8, 1966 · N1421A · Substantial damage NTSB MIA66D0446Accident · No injuriesClosedPiper PA-22 · Charlotte, NCMar 6, 1966 · N1438A · Substantial damage NTSB MIA66D0282Accident · No injuriesClosedPiper PA-20 · No Wilkesboro, NCOct 3, 1965 · N7738K · Substantial damage NTSB UNK65X1523Accident · Minor injuriesClosedPiper PA-18A · Gumberry, NCAug 3, 1965 · N1445A · Destroyed NTSB UNK65X0976Accident · Minor injuriesClosedPiper PA22 · Lagrange, NCDec 11, 1964 · N1285C · Destroyed NTSB UNK65X0860Accident · No injuriesClosedPiper PA22 · Selma, NCNov 27, 1964 · N8236C · Substantial damage NTSB UNK64X3370Accident · Serious injuriesClosedPiper J3C · Oxford, NCAug 13, 1964 · N3568N · Substantial damage NTSB UNK64X2106Accident · Minor injuriesClosedPiper PA-22 · Gibsonville, NCJun 4, 1964 · N2375A · Substantial damage