NTSB investigations: Aero Commander 680, 1983
3 cases on aircraft the registry lists as Aero Commander 680. 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 | 7 |
|---|---|
| 1965 | 7 |
| 1966 | 6 |
| 1967 | 4 |
| 1968 | 6 |
| 1969 | 5 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 4 |
| 1975 | 5 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2003 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141602'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141602'))
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 NYC83FA193Accident · 2 fatalField investigationFinal reportNorth American Rockwell 680 · Bayport, NYAt about 60 ft AGL black smoke was observed coming from the left eng. The acft continued a climb in a nose high attitude& the nose pitched down & the acft rolled inverted. Eng teardown revealed extensive damage to the supercharger assembly. The impeller shaft…NTSB ATL83FA277Accident · No injuriesField investigationFinal reportAero Commander 680 · Jacksonville, ALBefore takeoff, the acft had aprx 40 gal of fuel in the main tanks & 10 gal was added to each of the auxiliary tanks. The plt took off in hazy conditions for a short flt of apprx 10 min. While on downwind for a landing, he switched from the auxiliary to the…NTSB ATL83AA184Accident · 3 fatalFinal reportAero Commander 680 · Titusville, FLWitnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then…