NTSB investigations: Cessna 180, KS
16 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
| 1965 | 4 |
|---|---|
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1990 | 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\" = 'KS' 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" = 'KS' 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 MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB MKC86LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSA witness stated that the he observed the acft in a normal approach for landing but that it appeared slow. The witness observed the left wing drop just before the acft was to touchdown to the rwy. Tire scuff marks were seen by the witness on the rwy near…NTSB MKC81FCQ38Accident · No injuriesClosedCessna 180 · Mankato, KSNTSB MKC76FCG31Accident · Serious injuriesClosedCessna 180 · Edgerton, KSNTSB MKC75DC001Accident · No injuriesClosedCessna 180 · Wichita, KSNTSB MKC73DCQ04Accident · No injuriesClosedCessna 180 · Newton, KSNTSB MKC72FCG45Accident · No injuriesClosedCessna 180 · Edgerton, KSNTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNTSB MKC71FCQ31Accident · No injuriesClosedCessna 180 · Longton, KSNTSB MKC71DCQ21Accident · No injuriesClosedCessna 180 · Sharon Sprgs, KSNTSB MKC69A0031Accident · 2 fatalClosedCessna 180 · Victoria, KSNTSB MKC68D0528Accident · No injuriesClosedCessna 180 · Sublette, KSNTSB MKC66D0282Accident · No injuriesClosedCessna 180 · Oakley, KSNTSB MKC66D0212Accident · No injuriesClosedCessna 180 · Maize, KSNTSB MKC66F0177Accident · No injuriesClosedCessna 180 · Wichita, KSNTSB MKC66F0014Accident · No injuriesClosedCessna 180 · Salina, KS