NTSB investigations: Cessna 180J
4 cases on aircraft the registry lists as Cessna 180J, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1994 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072622')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072622')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 ANC07FA102Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe failure of the pilot's seat to engage, or remain engaged, and the pilot's inadvertent stall/mush during takeoff-initial climb. Contributing to the accident was the failure of maintenance personnel to comply with an FAA AD regarding the pilot's seat rails.NTSB NYC94LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Waynesburg, OHThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. A factor was a tailwind.NTSB ANC87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKAfter takeoff and during the initial climbout, the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft struck a row of trees at the departure end of the runway. The plts flt time was not reported or available.NTSB FTW84FA354Accident · 2 fatalField investigationFinal reportCessna 180J · Lafitte, LAWitnesses observed the acft approach an oil production platform located in a marshy area near the destination airstrip. They reported that the acft made an abrupt, steep left turn at 200 to 300 ft AGL, followed by what they described as an accelerated stall.…