Fatal NTSB investigations: Aero Commander 680FL P
4 cases on aircraft the registry lists as Aero Commander 680FL P. 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
| 1980 | 1 |
|---|---|
| 1983 | 1 |
| 1989 | 1 |
| 1998 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141610'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0141610'))
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 LAX99FA001Accident · 1 fatalField investigationFinal reportAero Commander 680 FPL · Palm Springs, CAThe pilot's failure to properly use the manual turbocharger wastegates and to monitor the manifold pressure during takeoff.NTSB LAX89FA307Accident · 1 fatalField investigationFinal reportAero Commander 680FLP · Kailua-Kona, HIInadequate maintenance, and operation by the pilot with known deficiencies in the aircraft. Factors related to the accident were: excessive wear in both engines, improper use of powerplant controls by the pilot, subsequent overtemperature/detonation in both…NTSB NYC83FA060Accident · 2 fatalField investigationFinal reportAero Commander 680FL P · Sunbury, PAAt aprx 0928 EST, the plt obtained a fss wx briefing by telephone. He was briefed on conditions of low ceilings, fog, light rain, drizzle, snow & blowing snow along his route. However, he did not ask about icing conditions & the briefing did not include a flt…NTSB FTW80FA096Accident · 2 fatalClosedAero Comdr 680FLP · Iola, TX