Skip to content

NTSB investigations: Lycoming 0-290 series, VA

18 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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.Aug 31, 2020 · N7323K · Destroyed NTSB ERA20CA248Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Culpeper, VAThe pilot’s failure to maintain directional control on landing resulting in a runway excursion and subsequent ground loop. Contributing to the outcome were the flight instructor’s inadequate remedial actions.Jul 10, 2020 · N8103C · Substantial damage NTSB ERA20LA055Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · New Market, VAThe pilot's improper touchdown, which resulted in a hard landing and an overload failure of the right main landing gear leg and its associated shock/dampener.Dec 15, 2019 · N1984A · Substantial damage NTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.Jul 25, 2009 · N20930 · Substantial damage NTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.May 13, 1998 · N1142C · Substantial damage NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.May 26, 1991 · N949Z · 2 aircraft · Substantial damage NTSB BFO88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisonburg, VAThe plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made…Aug 4, 1988 · N1665A · Substantial damage NTSB ATL81FIA03Accident · No injuriesClosedPiper PA-18 · Warrenton, VAMar 1, 1981 · N87869 · Substantial damage NTSB IAD70F0082Accident · 1 fatalClosedPiper PA-18A · Browns Store, VASep 4, 1969 · N8158C · Destroyed NTSB NYC66D0709Accident · No injuriesClosedPiper J3 · Chase City, VAMay 27, 1966 · N88685 · Substantial damage NTSB NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VADec 30, 1965 · N8522E · Substantial damage NTSB UNK65X1532Accident · No injuriesClosedPiper PA-22 · Clarksville, VASep 9, 1965 · N964A · Substantial damage NTSB NYC65F0157Accident · Minor injuriesClosedPiper PA-22 · Roanoke, VAApr 14, 1965 · N3713A · Destroyed NTSB NYC65F0156Accident · No injuriesClosedPilgram PR09 · Danville, VAMar 23, 1965 · N1554M · Substantial damage NTSB UNK65X0753Accident · No injuriesClosedPiper PA-22 · Moneta, VANov 18, 1964 · N3713A · Substantial damage NTSB UNK65X0256Accident · No injuriesClosedVolaire 10 · Diggs, VAOct 12, 1964 · N6663D · Substantial damage NTSB UNK64X3339Accident · No injuriesClosedChampion 7GC · Leesburg, VAAug 12, 1964 · N8522E · Substantial damage NTSB UNK64X2683Accident · Minor injuriesClosedPiper PA18 · Fredericksburg, VAJul 6, 1964 · N999D · Substantial damage