NTSB investigations: Continental IO-360 series, NM
17 cases on aircraft whose registry engine model is Continental IO-360 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2006 | 2 |
| 2010 | 1 |
| 2023 | 2 |
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 ('17025', '17045'))
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 ('17025', '17045'))
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 WPR23LA304Accident · Minor injuriesClass 3 · LimitedFinal reportVan Grouw R / Cantrell L White Lightning · Las Vegas, NMA reported partial loss of engine power during cruise flight for undetermined reasons.NTSB WPR23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna R172E · Alamogordo, NMFailure of the pilot to maintain control of the airplane during the landing.NTSB CEN10CA267Accident · No injuriesData collectionFinal reportCessna R172E · Alamogordo, NMAn unknown event that resulted in damage to the airplane's firewall.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB DEN06CA077Accident · No injuriesData collectionFinal reportCessna R172E (T-41C) · Albuquerque, NMthe pilot's failure to maintain aircraft control. A contributing factor was the wind gust.NTSB DEN03LA140Accident · No injuriesLimited investigationFinal reportCessna 337F · Las Cruces, NMLack of adequate power from the rear engine for undetermined reasons and the pilot's failure to maintain aircraft control during take-off. A contributing factor to the accident was the low altitude.NTSB DEN03TA103Accident · No injuriesFinal reportCessna R172E · Albuquerque, NMthe student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB FTW92DQA01Accident · 1 fatalFinal reportAir Trans. White Lightning · Aztec, NMThe inadvertent stall and the pilot's lack of experience in the accident aircraft.NTSB DEN84LA254Accident · No injuriesLimited investigationFinal reportCessna R172K · Los Alamos, NMThe pilot stated that he attempted a landing on rwy 27. The wind was reported to be from 090 degrees at 8 KTS. The plt stated that he touched down on the rwy and the acft skipped to the left. He applied power to go-around but determined that the airspeed was…NTSB FTW81DQG38Accident · No injuriesClosedCessna R172K · Milnesand, NMNTSB FTW81FQA04Accident · No injuriesClosedCessna T337G · Albuquerque, NMNTSB DEN79FQA44Accident · Minor injuriesClosedCessna 337 · Prewitt, NMNTSB DEN78FQD19Accident · Minor injuriesClosedCessna T337E · Deming, NMNTSB DEN78DQD03Accident · No injuriesClosedCessna 337F · Hachita, NMNTSB DEN76FQA05Accident · No injuriesClosedGlobe GC-1B · Albuquerque, NMNTSB DEN74FQD11Accident · Minor injuriesClosedCessna T337 · Sacramento, NM