Skip to content

NTSB investigations: Lycoming 0-290 series, AL

17 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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ERA25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Elberta, ALPilot’s decision to take off from a wet and unmaintained field that was unsuitable for airplane operations, resulting in a loss of control and subsequent nose over. Contributing was the pilot’s self-induced pressure to complete the flight.Jun 27, 2025 · N3228B · Substantial damage NTSB ERA13LA041Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Fairhope, ALThe Grumman pilot’s loss of directional control during landing for undetermined reasons because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the Piper pilot…Oct 26, 2012 · N26380 · 2 aircraft · Substantial damage NTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.Aug 23, 2009 · N1415A · Substantial damage NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.Apr 4, 2009 · N8560E · Substantial damage NTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.Oct 19, 2008 · N7324K · Substantial damage NTSB ATL90DKJ04Accident · No injuriesFinal report67 Flying Dutchman D1/LFD-13 · Tuscaloosa, ALMaintenance personnel who performed an improper modification of the propeller blade.May 27, 1990 · N1113D · Substantial damage NTSB ATL90DKJ03Accident · Minor injuriesFinal reportJolly Bakeng Duce · Brownsboro, ALFailure of the pilot to maintain the reference speed on approach and establish a proper glidepath.Apr 12, 1990 · N72WJ · Substantial damage NTSB MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…Dec 13, 1987 · N3512A · Destroyed NTSB ATL82DA063Accident · Minor injuriesFinal reportSmith Mini · Brownsboro, ALThe pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.…Mar 2, 1982 · N37WS · Substantial damage NTSB ATL81FKJ24Accident · 1 fatalClosedPiper J3C-65 · Fadette, ALJul 13, 1981 · N2220M · Substantial damage NTSB MIA79DKJ43Accident · Serious injuriesClosedPiper PA-18 · Ozark, ALJun 13, 1979 · N46761 · Substantial damage NTSB MIA78FKJ78Accident · Serious injuriesClosedBreezy I · Cullman, ALJul 29, 1978 · N45870 · Substantial damage NTSB MIA76DKJ54Accident · No injuriesClosedBreezy RLU-1 · Sylacauga, ALMar 8, 1976 · N55WW · Substantial damage NTSB MIA75DKJ63Accident · No injuriesClosedPiper PA-20 · Columbiana, ALJun 21, 1975 · N7059K · Substantial damage NTSB MIA73DKJ25Accident · Minor injuriesClosedPiper PA-22 · Atmore, ALSep 27, 1972 · N1147C · Substantial damage NTSB MIA69D0075Accident · No injuriesClosedCessna 180 · Alexander Cty, ALJul 19, 1968 · N4971A · 2 aircraft · Minor damage NTSB UNK64X0493Accident · No injuriesClosedPiper PA22 · Weaver, ALFeb 8, 1964 · N1804A · Substantial damage