NTSB investigations: Continental C90 series, NM
19 cases on aircraft whose registry engine model is Continental C90 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 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2023 | 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 ('17009'))
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 ('17009'))
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 WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.NTSB DEN99LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Belen, NMThe pilot's failure to maintain aircraft control. Factors were his inadequate compensation for the gusty crosswind conditions, and the airplane manufacturer's failure to provide adequate performance data.NTSB FTW97LA076Accident · No injuriesLimited investigationFinal reportCessna 140A · Albuquerque, NMThe fracture of the right main landing gear for an undetermined reason.NTSB FTW96LA367Accident · Minor injuriesLimited investigationFinal reportJackson Sonerai I · Santa Fe, NMthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.NTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.NTSB DEN84FA278Accident · 2 fatalField investigationFinal reportPiper PA-18 · Meadow Lake, NMAccording to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about…NTSB DEN78FQA37Accident · Minor injuriesClosedAlon A-2 · Albuquerque, NMNTSB DEN72FQD34Accident · No injuriesClosedLuscombe 8F · Deming, NMNTSB DEN72DQD19Accident · No injuriesClosedChampion 7EC · Montoya, NMNTSB DEN71DQA24Accident · No injuriesClosedAlon A-2 · Los Lunas, NMNTSB DEN70F0099Accident · Minor injuriesClosedLuscombe 8F · Las Cruces, NMNTSB DEN70F0035Accident · Serious injuriesClosedCessna 140 · Gallup, NMNTSB DEN69D0103Accident · No injuriesClosedCessna 140A · Las Cruces, NMNTSB DEN68D0156Accident · Minor injuriesClosedAlon A-2 · Torreon, NMNTSB DEN67F0098Accident · No injuriesClosedLark 95 · Deming, NMNTSB DEN66F0159Accident · No injuriesClosedAlon A2 · Sunland Pk, NMNTSB DEN66D0087Accident · No injuriesClosedAeronca L-16 · Grants, NMNTSB UNK64X3658Accident · No injuriesClosedLuscombe 8F · Albuquerque, NMNTSB UNK64X1267Accident · 2 fatalClosedChampion 7FC · Tortugas, NM