NTSB investigations: Cessna 180H, ME
8 cases on aircraft the registry lists as Cessna 180H. 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 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\" = 'ME' 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 ('2072618'))
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" = 'ME' 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 ('2072618'))
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 NYC83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Greenville, METhe wx was estimated at 2,000 to 2,500 ft overcast when the flt departed Greenville at 1820. Horseshoe pond is 1,500 ft MSL & surrounded by 2,700 ft mountains. As the acft approached the pass the pond was visible. However a south wind prevailed & fog had…NTSB NYC82FA193Accident · 2 fatalField investigationFinal reportCessna 180H · Porter, METhe acft was taking off from a pond which is about 4,200 ft at its longest length. A power line extends across the pond about 2,000 ft from the south end. The acft was observed to takeoff to the north remaining on the water while passing under the wires. The…NTSB NYC81FNC01Accident · Minor injuriesClosedCessna 180 · Millinocket, MENTSB NYC81FNC16Accident · No injuriesClosedCessna 180 · Greenville, MENTSB NYC80FNC47Accident · No injuriesClosedCessna 180H · Livermore, MENTSB NYC79DNC13Accident · No injuriesClosedCessna 180 · Bangor, MENTSB NYC74DNC09Accident · No injuriesClosedCessna 180 · Greenville, MENTSB NYC72FNC32Accident · No injuriesClosedCessna 180H · Chamberlain, ME