Skip to content

NTSB investigations: Lycoming 0-290 series, MN

35 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Walker, MNThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action during a go-around.Jul 1, 2022 · N1136 · Substantial damage NTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Oct 27, 2019 · N2621P · Destroyed NTSB CEN13LA417Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Mapleton, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing to unsuitable terrain.Jul 16, 2013 · N663A · Substantial damage NTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.Mar 25, 2006 · N1579A · Substantial damage NTSB CHI03LA007Accident · No injuriesLimited investigationFinal reportMadewell EAA-Biplane-P · Forest Lake, MNThe loss of engine power for undetermined reasons. A related factor was the swampy terrain.Oct 9, 2002 · N21WL · Substantial damage NTSB CHI02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear Lake, MNThe loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.Jan 20, 2002 · N7113K · Substantial damage NTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.Jul 4, 1999 · N535Y · Substantial damage NTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.May 19, 1995 · N1097A · Substantial damage NTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.Feb 2, 1993 · N3854M · Substantial damage NTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.Mar 24, 1991 · N7010K · Substantial damage NTSB CHI85LA319Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Madelia, MNDuring cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over.Jul 28, 1985 · N7619K · Substantial damage NTSB CHI83LA252Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Blackduck, MNThe acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…Jun 12, 1983 · N2487M · Substantial damage NTSB CHI82DER09Accident · No injuriesClosedPiper PA-20 · Lakeville, MNOct 27, 1981 · N7027K · Substantial damage NTSB MKC78DER42Accident · No injuriesClosedPiper PA-22 · Westbrook, MNApr 30, 1978 · N3498A · Substantial damage NTSB MKC76DER50Accident · No injuriesClosedPiper PA-22 · Thief Riv Fls, MNFeb 1, 1976 · N1672A · Substantial damage NTSB MKC76DER40Accident · Minor injuriesClosedPiper PA-22 · Browerville, MNNov 18, 1975 · N2450A · Substantial damage NTSB MKC74DER17Accident · No injuriesClosedPiper J-3 · Blackduck, MNSep 30, 1973 · N88553 · Substantial damage NTSB MKC73DER52Accident · Serious injuriesClosedPiper PA-18 · Fosston, MNApr 29, 1973 · N2461A · Substantial damage NTSB MKC72DER11Accident · No injuriesClosedChampion 7GC · Hibbing, MNAug 2, 1971 · N8578E · Substantial damage NTSB MKC71FDM37Accident · No injuriesClosedPiper PA-20 · Big Fork, MNDec 9, 1970 · N7742K · Substantial damage NTSB MKC69D0192Accident · No injuriesClosedPiper PA-22 · Holdingford, MNSep 2, 1968 · N1335C · Substantial damage NTSB MKC69F0090Accident · No injuriesClosedPiper PA-22 · Pequot Lakes, MNAug 20, 1968 · N806A · Substantial damage NTSB MKC68F0273Accident · Minor injuriesClosedThorp T-18 · Anoka, MNOct 22, 1967 · N18117 · Substantial damage NTSB MKC68F0236Accident · Serious injuriesClosedErnst Eaa Biplan · Cambridge, MNSep 4, 1967 · N530C · Substantial damage NTSB MKC68F0188Accident · No injuriesClosedStits SA3B · Owatonna, MNSep 2, 1967 · N1079Z · Substantial damage NTSB MKC68F0035Accident · No injuriesClosedChampion 7GC · Montevideo, MNJun 22, 1967 · N4867E · Substantial damage NTSB MKC67F0244Accident · No injuriesClosedWittman AM-1 · Bloomington, MNSep 25, 1966 · N319M · Substantial damage NTSB MKC66F0239Accident · Minor injuriesClosedChampion 7GC · Silver Bay, MNAug 15, 1965 · N8972R · Substantial damage NTSB MKC66F0022Accident · Minor injuriesClosedPiper PA-22 · Detroit Lakes, MNJun 3, 1965 · N806A · Substantial damage NTSB MKC66F0098Accident · No injuriesClosedPiper PA-22 · Fairbault, MNMay 30, 1965 · N2621P · Substantial damage NTSB MKC65F0031Accident · No injuriesClosedPiper PA-20 · Bemidji, MNJan 4, 1965 · N7020K · Substantial damage NTSB UNK64X2526Accident · No injuriesClosedPiper PA-18A · Angus, MNJun 27, 1964 · N2585A · Substantial damage NTSB UNK64X1600Accident · No injuriesClosedPiper PA22 · Windom, MNMay 3, 1964 · N1395C · Substantial damage NTSB UNK64X1360Accident · No injuriesClosedPiper PA20 · So St Paul, MNApr 18, 1964 · N3585A · Substantial damage NTSB UNK64X0776Accident · No injuriesClosedPiper PA18 · Intl Falls, MNMar 1, 1964 · N165T · Substantial damage