NTSB investigations: Aero Commander 100-180, 1988
4 cases on aircraft the registry lists as Aero Commander 100-180. 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
| 1968 | 1 |
|---|---|
| 1969 | 2 |
| 1970 | 5 |
| 1971 | 6 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 5 |
| 1976 | 1 |
| 1977 | 3 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 2 |
| 1993 | 5 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140208'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140208'))
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 SEA88FA160Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · John Day, ORWhile elk spotting in mountainous terrain, the aircraft collided with trees in a nose low turn similar to the intermediate stages of a stall. A severe post impact fire erupted. The density altitude at the accident site elevation was approximately 10,100 feet.…NTSB MIA88FA223Accident · Serious injuriesField investigationFinal reportRockwell 100-180 · Paxton, FLPlt's license was suspended at time of accident and his medical certificate was expired. Plt failed to get weather briefing prior to departure. Plt continued flt into deteriorating weather conditions and while attempting to land at a private airport due to…NTSB MKC88LA127Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Lowell, ARAbout one hour after takeoff, the plt noted that the eng began to run rough. He reduced the power to 2000 RPM & enriched the mixture. He continued flying for about another hour, then the eng lost power. The plt attempted an emergency landing on a frontage…NTSB FTW88LA045Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Mineola Quitman, TXDuring a practice touch and go landing, the engine back fired and then surged. At about 150' AGL the engine RPM dropped about 80% and the pilot attempted to make an emergency landing in an open field. The aircraft flew over a trash dump and between two trees.…