NTSB investigations: Temco D-16
15 cases on aircraft the registry lists as Temco D-16. 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
| 1965 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1978 | 2 |
| 1986 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230602'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230602'))
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 ANC86LA120Accident · No injuriesLimited investigationFinal reportNavion D-16 · Kotzebue, AKThe left fuel valve was in the off position at the time of the takeoff. The pilot attempted to lift-off below the recommended VMC speed. The pilot lost control of the aircraft causing the aircraft to exit the left side of the runway into a lake.NTSB MKC78DCQ30Accident · No injuriesClosedUniv Acft D-16 · Valley Center, KSNTSB SEA78DYK15Accident · No injuriesClosedTemco D-16 · Redmond, ORNTSB OAK76FXQ66Accident · No injuriesClosedTwin Engine D-16 · Carson City, NVNTSB DEN76FQD26Accident · No injuriesClosedTwin Engine D-16 · Las Cruces, NMNTSB OAK76O0003Accident · No injuriesClosedTwin Engine D-16 · Bahia Concpcn, MexicoNTSB MIA74FKG63Accident · Serious injuriesClosedTemco D-16 · Marietta, GANTSB DEN72FTE27Accident · No injuriesClosedTemco D-16 · Trinidad, CONTSB CHI72FEE11Accident · Minor injuriesClosedUniv Acft D-16 · Gilberts, ILNTSB OAK71AP055Accident · 2 fatalClosedTemco D-16 · S.Lk Tahoe, CANTSB NYC70D0148Accident · No injuriesClosedRiley D-16 · Ripley, NYNTSB CHI68F0595Accident · No injuriesClosedTemco D-16 · Sycamore, ILNTSB OAK68D0113Accident · No injuriesClosedTemco D-16 · Lake Tahoe, CANTSB MKC67D0504Accident · No injuriesClosedTemco D-16 · Loretto, MexicoNTSB DEN66F0078Accident · Serious injuriesClosedNavion D-16 · Grand Canyon, AZ