Skip to content

NTSB investigations: Lycoming 0-290 series, NE

28 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

19652026

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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CEN22LA260Accident · Minor injuriesClass 3 · LimitedFinal reportSmith Miniplane DSA-1 · Union, NEThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 19, 2022 · N208C · Substantial damage NTSB CEN12CA173Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hebron, NEThe pilot’s did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.Feb 25, 2012 · N1213C · Substantial damage NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.Mar 2, 2008 · N3212B · Substantial damage NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.Aug 17, 2007 · N89492 · Substantial damage NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…Jul 4, 2007 · N3737A · Substantial damage NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.Jun 18, 2006 · N1270C · Substantial damage NTSB CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.Sep 30, 2005 · N4747G · Substantial damage NTSB CHI05CA036Accident · No injuriesData collectionFinal reportSpaulding Tailwind W-8 · Davey, NEThe loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.Nov 24, 2004 · N191AS · Substantial damage NTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.Jul 13, 1998 · N3770A · Substantial damage NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.Oct 22, 1992 · N5592H · Substantial damage NTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.Sep 27, 1992 · N1270C · Substantial damage NTSB MKC81DCJ22Accident · No injuriesClosedPiper PA-18A · Imperial, NEJul 16, 1981 · N3591A · Substantial damage NTSB MKC77DCJ36Accident · No injuriesClosedPiper PA-20 · Grant, NEAug 4, 1977 · N7477K · Substantial damage NTSB MKC77DCJ19Accident · No injuriesClosedPiper PA-18A · Oshkosh, NEMay 12, 1977 · N3591A · Substantial damage NTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NEDec 1, 1973 · N3323A · Substantial damage NTSB MKC73FCJ30Accident · No injuriesClosedCessna 140A · Mc Cook, NEMar 1, 1973 · N5687C · Substantial damage NTSB MKC73DCJ13Accident · Minor injuriesClosedPiper PA-18 · Paxton, NEAug 11, 1972 · N1894A · Substantial damage NTSB MKC72FCJ72Accident · No injuriesClosedPiper PA-22 · Omaha, NEJun 3, 1972 · N3377A · Destroyed NTSB MKC72FCJ63Accident · Serious injuriesClosedPiper PA-22 · Lincoln, NEMay 21, 1972 · N8525C · Destroyed NTSB MKC71FCJ75Accident · No injuriesClosedChampion 7GC · Ord, NEJun 20, 1971 · N4856E · Substantial damage NTSB MKC70D0138Accident · No injuriesClosedPiper PA-18 · Merriman, NEAug 1, 1969 · N2368A · Substantial damage NTSB MKC69F0040Accident · No injuriesClosedPiper PA-20 · Fort Calhoun, NEJul 13, 1968 · N7044K · Substantial damage NTSB MKC68D0448Accident · No injuriesClosedPiper PA-20 · Chadron, NEFeb 4, 1968 · N2274A · Substantial damage NTSB MKC68D0379Accident · No injuriesClosedPiper PA-22 · Chadron, NEDec 6, 1967 · N3337B · Substantial damage NTSB MKC68F0140Accident · No injuriesClosedPiper PA-18 · Alliance, NEJun 28, 1967 · N1277A · Substantial damage NTSB MKC67F0037Accident · Minor injuriesClosedPiper PA-12 · Madison, NEJun 27, 1966 · N2564M · Substantial damage NTSB MKC66D0577Accident · No injuriesClosedPiper PA-22 · Sidney, NEMay 21, 1966 · N1399C · Substantial damage NTSB MKC66D0054Accident · No injuriesClosedPiper PA-18A · Sutherland, NEJun 28, 1965 · N1894A · Substantial damage