NTSB investigations: Cessna 180, AR
11 cases on aircraft the registry lists as Cessna 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
| 1964 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1987 | 1 |
| 1995 | 1 |
| 1997 | 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.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602'))
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 FTW99LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Springdale, ARThe pilot's improper recovery from a bounced landing resulting in a ground loop. A factor was the pilot's improper landing flare.NTSB FTW97LA279Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlisle, ARthe pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).NTSB FTW95LA189Accident · No injuriesLimited investigationFinal reportCessna 180 · Little Rock, ARThe pilot's failure to maintain directional control due to the excessive taxi speed.NTSB MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…NTSB FTW74AF007Accident · 4 fatalClosedCessna 180 · Monticello, ARNTSB FTW73FPG45Accident · No injuriesClosedCessna 180 · Stuttgart, ARNTSB FTW72FPG66Accident · Serious injuriesClosedCessna 180 · Heber Springs, ARNTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNTSB FTW66F0544Accident · No injuriesClosedCessna 180 · West Memphis, ARNTSB UNK65X0117Accident · No injuriesClosedCessna 180 · West Memphis, ARNTSB UNK64X1092Accident · No injuriesClosedCessna 180 · W Memphis, AR