NTSB investigations: Continental I0-470 series, NM
4 cases on aircraft whose registry engine model is Continental I0-470 series, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
Where
Latest 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 ('17027')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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 ('17027')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN85FA055Accident · 2 fatalField investigationFinal reportCessna 310N · Edgewood, NMThe pvt rated pilot did not hold a multiengine or instrument rating. The pilot and passenger were returning from vacation. A witness near the accident site stated that she saw the aircraft descend out of a low over last at a very steep nose down angle. The…NTSB DEN85FA009Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Pinehill, NMLeft wing failed inflight. Thunderstorms in area at time of crash. Pilot was enroute from California to new jersey, had been flying 4 hours, 18 minutes. Awake at least 7 hours. Transited 1 time zone. No record of weather briefing or flight plan filed. Pilot…NTSB DEN84FA223Accident · 3 fatalField investigationFinal reportCessna 310H · Questa, NMThe acft collided with rising terrain at the 12500 ft level. The summit was about 200 ft above the crash site. A friend of the plt was interviewed by the iic from NTSB. This friend was the host of the 3 accident victims for the weekend at his gunnison ranch.…NTSB FTW83LA160Accident · No injuriesLimited investigationFinal reportBeech K35 · Torreon, NMThe pilot, who was not certificated, stated that prior to departure he received a wx briefing by telephone from the fss. Enroute, after making several heading changes to avoid wx he found himself surrounded by low ceiling and precipitation. He decided to make…