Final NTSB investigations: Aero Commander 680FL P
8 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 | 3 |
|---|---|
| 1983 | 1 |
| 1989 | 2 |
| 1998 | 2 |
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed'
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 CHI98LA105Accident · Minor injuriesLimited investigationFinal reportAero Commander 680FLP · Fond Du Lac, WIthe pilot's misjudged weather evaluation . Factors were turbulence, the pilot's inability to attain a proper climb rate, unsuitable terrain encountered in the landing area, and crops.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 FTW89LA077Accident · No injuriesLimited investigationFinal reportGulfstream 680FLP · Lohn, TXArson undertaken to conceal illegal activity.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 ATL81FLG02Accident · Serious injuriesClosedAero Comdr 680FLP · Columbia, SCNTSB LAX80FVD32Accident · No injuriesClosedAero Comdr 680FLP · Emeryville, CANTSB FTW80FA096Accident · 2 fatalClosedAero Comdr 680FLP · Iola, TX