NTSB investigations: Lycoming 0-290 series, NM
14 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2008 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'NM' 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" = 'NM' 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" DESCRun 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 DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.NTSB FTW82DA147Accident · No injuriesFinal reportTailwind A-M-1 · Carlsbad, NMThe pilot attempted a precautionary landing on a road due to deteriorating weather and an intermittent engine problem. The pilot stated he lost directional control due to gusty winds and the aircraft nosed over.NTSB DEN78DQA52Accident · No injuriesClosedPiper PA-22 · Datil, NMNTSB DEN77DQA06Accident · No injuriesClosedThorp T18 · Santa Fe, NMNTSB DEN76AD020Accident · 2 fatalClosedChampion 7GC · Lordsburg, NMNTSB DEN75DQA25Accident · No injuriesClosedPiper PA-22 · Ruidoso, NMNTSB DEN74DQA08Accident · No injuriesClosedChampion 7GC · Albuquerque, NMNTSB DEN68D0225Accident · No injuriesClosedPiper PA-18 · Cimarron, NMNTSB DEN68F0040Accident · Serious injuriesClosedChampion 7GC · Albuquerque, NMNTSB DEN68D0042Accident · No injuriesClosedPiper PA-22 · Ramah, NMNTSB DEN66D0068Accident · No injuriesClosedPiper PA-22 · Shiprock, NMNTSB UNK64X1781Accident · No injuriesClosedPiper PA12 · Las Cruces, NM