NTSB investigations: Cessna 180B
4 cases on aircraft the registry lists as Cessna 180B, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1995 | 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 ('2072606')
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\" = 220))
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 ('2072606')
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" = 220))
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 ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.NTSB SEA88LA168Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Dixie, IDWhile on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the…NTSB MKC87LA175Accident · No injuriesLimited investigationFinal reportCessna 180B · Atkinson, NEWitnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to…NTSB SEA83FYA01Accident · 1 fatalFinal reportCessna 180B · Near Irwin, IDThe pilot and two passengers were on a local flight to spot moose. While flying low with the flaps extended, the aircraft collided with trees on rising terrain, then impacted on the ground and burned. Initial impact occurred with a 75 ft tall tree, about 60…