Fatal NTSB investigations: Continental W670 series, 1982
2 cases on aircraft whose registry engine model is Continental W670 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 | 3 |
|---|---|
| 1966 | 1 |
| 1968 | 2 |
| 1970 | 5 |
| 1972 | 1 |
| 1974 | 3 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 2 |
| 1980 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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 year(c.\"eventDate\") = 1982
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018'))
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 year(c."eventDate") = 1982
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018'))
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 CHI82FA290Accident · 3 fatalField investigationFinal reportStarduster II · Oshkosh, WIBoth acft were operating in the fly-by (no radio) pattern during the annual eaa convention. According to participant records both plts had received fly-by pattern briefings. Both acft were observed to be in the southern most portion of the upwind leg of the…NTSB SEA82DYE07Accident · 1 fatalFinal reportStarduster TOO SA300 · Sequim Bay, WAWhile flying over a lake at low altitude, the left wing of the aircraft struck wires on a moored sailboat about 50 ft above the water level. Three witnesses report that just prior to the collision, the pilot dipped or wagged his wings and waved at them. After…