NTSB investigations: Continental O-470 series, NM
126 cases on aircraft whose registry engine model is Continental O-470 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, newest first
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 ('17026'))
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 ('17026'))
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 FTW84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Portales, NMThe plt had made a successful landing in an unimproved wheat field. The acft had stopped & as the plt was making a 180 deg turn back the wind caught a wing causing the acft to nose over onto its back. The plt stated that during the turn the right main gear…NTSB FTW84FA032Accident · 1 fatalField investigationFinal reportCessna 182Q · Columbus, NMThe non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500…NTSB FTW84LA017Accident · No injuriesLimited investigationFinal reportCessna 310B · Santa Fe, NMWhile practicing landings, the left eng power was reduced to simulate an eng failure while the acft was on downwind. The student retracted the gear & continued the apch, but forgot to reextend the gear. The instructor also forgot & the acft was landed with…NTSB FTW82DA395Accident · Minor injuriesFinal reportCessna 182B · Albuquerque, NMThe pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon…NTSB FTW82DA298Accident · No injuriesFinal reportCessna 182E · Albuquerque, NMThe pilot stated that after a normal approach, the aircraft touched down at about 90 mph on the first 1/4 to 1/3 of the runway. He raised the flaps and applied brakes. He noticed that there was insufficient braking action to stop on the wet runway, but by the…NTSB FTW80FQA30Accident · No injuriesClosedCessna 180K · Santa Fe, NMNTSB DEN80FQA21Accident · No injuriesClosedCessna 182 · Taos, NMNTSB DEN80FQA19Accident · Serious injuriesClosedBeech A-45 · Taos, NMNTSB DEN80DQD02Accident · Minor injuriesClosedCessna 182N · Hacienda Sr Ln, NMNTSB DEN80FA007Accident · 1 fatalClosedCessna 182P · Farmington, NMNTSB DEN79DQA34Accident · No injuriesClosedCessna 182 · Roswell, NMNTSB DEN79DQD11Accident · No injuriesClosedCessna 182Q · Timberon, NMNTSB DEN79DQD10Accident · No injuriesClosedCessna 180 · Las Cruces, NMNTSB DEN79FQD08Accident · Minor injuriesClosedCessna 182 · Deming, NMNTSB DEN79FQA13Accident · No injuriesClosedCessna C-182P · Albuquerque, NMNTSB DEN79FQA03Accident · No injuriesClosedCessna 182P · Grants, NMNTSB DEN78FQA58Accident · Minor injuriesClosedCessna 182 · L1ndrith, NMNTSB DEN78FQA54Accident · No injuriesClosedCessna 182 · Farmington, NMNTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMNTSB DEN77FQA45Accident · No injuriesClosedCessna T210 · Abiquiu, NMNTSB DEN77DQG02Accident · No injuriesClosedCessna 180H · Jal, NMNTSB DEN77DQA05Accident · No injuriesClosedCessna 182 · Farmington, NMNTSB DEN76FQA48Accident · No injuriesClosedCessna 180 · Farmington, NMNTSB DEN76FQA39Accident · No injuriesClosedCessna 182A · Espanola, NMNTSB DEN76FQA23Accident · Serious injuriesClosedCessna 180 · Zuni, NMNTSB DEN75FQD23Accident · No injuriesClosedCessna 182 · Las Cruces, NMNTSB DEN75DQA46Accident · No injuriesClosedCessna 182E · Roy, NMNTSB DEN75DQA45Accident · No injuriesClosedCessna 180 · Cimarron, NMNTSB DEN75DQG08Accident · No injuriesClosedCessna 182B · Clovis, NMNTSB DEN75DQA36Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB DEN75DQA35Accident · No injuriesClosedCessna 182 · Gallup, NMNTSB DEN74FQA47Accident · No injuriesClosedCessna 182B · Farmington, NMNTSB DEN74FQD21Accident · No injuriesClosedCessna 182K · Ruidoso, NMNTSB DEN74FQA27Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB DEN74DQA22Accident · No injuriesClosedCessna 182G · Mid Valley, NMNTSB DEN74DQA16Accident · No injuriesClosedCessna 182 · Gallop, NMNTSB DEN72FQA36Accident · Minor injuriesClosedCessna 180 · Albuquerque, NMNTSB DEN72FQA33Accident · No injuriesClosedCessna 182 · Ruidoso, NMNTSB DEN71DQA55Accident · No injuriesClosedCessna 182G · Albuquerque, NMNTSB DEN70DQG06Accident · No injuriesClosedCessna 180A · Clovis, NMNTSB DEN69D0253Accident · No injuriesClosedCessna 182E · Albuquerque, NMNTSB DEN69A0036Accident · 2 fatalClosedCessna 180 · Tucumcari, NMNTSB DEN69D0175Accident · No injuriesClosedCessna 182 · Reserve, NMNTSB DEN69F0196Accident · No injuriesClosedCessna 310 · Albuquerque, NMNTSB DEN69D0082Accident · No injuriesClosedCessna 182K · Albuquerque, NMNTSB DEN69F0066Accident · Minor injuriesClosedCessna 182K · Mountainair, NMNTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NMNTSB DEN68F0159Accident · No injuriesClosedCessna 182 · Albuquerque, NMNTSB DEN68D0162Accident · No injuriesClosedCessna 182 · Hobbs, NMNTSB DEN68D0161Accident · No injuriesClosedCessna 182 · Chama, NM