Skip to content

NTSB investigations: Lycoming 0-290 series

1,553 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, newest first

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."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.\"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."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 DEN75FTM03Accident · Serious injuriesClosedPiper PA-18 · Tremonton, UTJul 2, 1974 · N3351A · Substantial damage NTSB LAX74FUA24Accident · No injuriesClosedPiper PA-22 · Long Beach, CAJun 23, 1974 · N3523A · Substantial damage NTSB CHI74FEI46Accident · Minor injuriesClosedPiper PA-20 · Fremont, OHJun 19, 1974 · N7335K · Substantial damage NTSB MIA74FLE07Accident · No injuriesClosedPiper J3C-65 · Ormond Beach, FLJun 13, 1974 · N30400 · Substantial damage NTSB FTW74DQG65Accident · Serious injuriesClosedPitts SPL · Tulia, TXJun 6, 1974 · N55HB · Substantial damage NTSB OAK74DYE45Accident · Minor injuriesClosedKasper 100 · Arlington, WAMay 28, 1974 · N88818 · Substantial damage NTSB ANC74DAH12Accident · No injuriesClosedPiper PA-20 · Mcgrath, AKMay 24, 1974 · N4647V · Substantial damage NTSB NYC74DNC44Accident · No injuriesClosedPiper PA-18 · Winslow, MEMay 19, 1974 · N1473C · Substantial damage NTSB ANC74AA072Accident · No injuriesClosedCurtis-Wrt C-46 · Fairbanks, AKMay 13, 1974 · N1663M · 2 aircraft · Minor damage NTSB CHI74FEC42Accident · Minor injuriesClosedPiper PA-22 · Cambridge Jt, MIApr 27, 1974 · N2240A · Substantial damage NTSB SEA74DTA21Accident · No injuriesClosedPiper PA-22 · Melstone, MTApr 9, 1974 · N648A · Substantial damage NTSB ANC74DAG96Accident · No injuriesClosedPiper PA-14 · Mcgrath, AKApr 8, 1974 · N4241H · Substantial damage NTSB ANC74DAG95Accident · No injuriesClosedPiper PA-18 · Eek, AKMar 24, 1974 · N1582P · Substantial damage NTSB ANC74FAA29Accident · Serious injuriesClosedPiper PA-18 · Nome, AKMar 22, 1974 · N1046A · Substantial damage NTSB LAX74FUD05Accident · No injuriesClosedPiper PA-22 · Compton, CAMar 8, 1974 · N1542P · Substantial damage NTSB LAX74DUG39Accident · No injuriesClosedSpezio DAL-1 · Redlands, CAJan 26, 1974 · N21HM · Substantial damage NTSB FTW74DPJ19Accident · No injuriesClosedPiper PA-20 · Woodward, OKJan 14, 1974 · N1580A · Substantial damage NTSB FTW74FPA14Accident · Minor injuriesClosedPiper PA-22 · Dallas, TXJan 6, 1974 · N8236C · Substantial damage NTSB DEN74DTE36Accident · No injuriesClosedPiper PA-18 · Aurora, COJan 6, 1974 · N8655C · Substantial damage NTSB IAD74FKM31Accident · No injuriesClosedChampion 7HC · Thomasville, NCDec 23, 1973 · N8555E · Substantial damage NTSB SEA74DTI15Accident · No injuriesClosedPiper PA-22 · Hogeland, MTDec 15, 1973 · N803A · Substantial damage NTSB DEN74DTE33Accident · No injuriesClosedPiper PA-22 · Byers, CODec 10, 1973 · N8585C · Substantial damage NTSB FTW74FPD31Accident · Minor injuriesClosedPiper PA-22 · Grapevine, TXDec 6, 1973 · N1176C · Substantial damage NTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NEDec 1, 1973 · N3323A · Substantial damage NTSB FTW74DPD28Accident · No injuriesClosedPiper PA-20 · Denton, TXNov 16, 1973 · N7714K · Substantial damage NTSB ANC74AA044Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNov 12, 1973 · N3872Z · 2 aircraft · Substantial damage NTSB CHI74DEI11Accident · No injuriesClosedPiper PA-22 · Norwalk, OHOct 31, 1973 · N2573A · Destroyed NTSB SEA74FYA14Accident · Minor injuriesClosedPiper PA-22 · Boise, IDOct 17, 1973 · N996A · Substantial damage NTSB DEN74FTM06Accident · Minor injuriesClosedWittman W-8 · Salt Lake City, UTOct 4, 1973 · N11511 · Substantial damage NTSB MKC74DER17Accident · No injuriesClosedPiper J-3 · Blackduck, MNSep 30, 1973 · N88553 · Substantial damage NTSB ANC74DAA14Accident · No injuriesClosedPiper PA-20 · Bettles, AKSep 22, 1973 · N1775A · Substantial damage NTSB FTW74FPJ09Accident · No injuriesClosedCessna 140A · Bethany, OKSep 3, 1973 · N1108D · Substantial damage NTSB ANC74DAG28Accident · No injuriesClosedPiper J5A · Skwentna, AKAug 26, 1973 · N41181 · Substantial damage NTSB ANC74DAG27Accident · No injuriesClosedPiper PA-12 · Anchorage, AKAug 26, 1973 · N4112M · Substantial damage NTSB ANC74DAG19Accident · No injuriesClosedPiper PA-12 · Port Lions, AKAug 12, 1973 · N4008M · Substantial damage NTSB SEA74D7A05Accident · No injuriesClosedPiper PA-22 · Birney, MTJul 28, 1973 · N3369B · Substantial damage NTSB DEN74DQA08Accident · No injuriesClosedChampion 7GC · Albuquerque, NMJul 21, 1973 · N8547E · Substantial damage NTSB IAD74FKW04Accident · Minor injuriesClosedPiper PA-22 · Oak Ridge, TNJul 13, 1973 · N8860C · Substantial damage NTSB ANC74FAA01Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKJul 7, 1973 · N7145K · Substantial damage NTSB MIA73DKU11Accident · No injuriesClosedCessna 150 · Belle Glade, FLJun 30, 1973 · N60177 · Substantial damage NTSB CHI73DEA42Accident · No injuriesClosedPiper PA-20 · Portland, INJun 25, 1973 · N8290C · Substantial damage NTSB ANC73DAG99Accident · No injuriesClosedPiper PA-20 · Cantwell, AKMay 30, 1973 · N7721K · Substantial damage NTSB IAD73DKM42Accident · No injuriesClosedBerg-Aero 19181A · Archdale, NCMay 22, 1973 · N2418 · Substantial damage NTSB MIA73DLG46Accident · No injuriesClosedPiper PA-22 · Rock Hill, SCMay 17, 1973 · N606A · Substantial damage NTSB MKC73DER52Accident · Serious injuriesClosedPiper PA-18 · Fosston, MNApr 29, 1973 · N2461A · Substantial damage NTSB FTW73FRA25Accident · No injuriesClosedPiper PA-20 · Vidor, TXApr 25, 1973 · N7076K · Substantial damage NTSB MIA73DLD71Accident · No injuriesClosedPiper PA-22 · Seminole, FLApr 19, 1973 · N3385B · Substantial damage NTSB IAD73FLQ24Accident · Minor injuriesClosedSmith DSA-1 · Elizabethtown, KYApr 8, 1973 · N8890 · Substantial damage NTSB LAX73FUJ61Accident · No injuriesClosedPiper PA-22 · Florence, AZApr 1, 1973 · N3346B · Substantial damage NTSB DEN73FTC21Accident · Minor injuriesClosedPiper PA-18A · Bosler, WYMar 18, 1973 · N1385C · Destroyed