NTSB investigations: Cessna 182F, MO
12 cases on aircraft the registry lists as Cessna 182F. 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 | 3 |
|---|---|
| 1967 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 2005 | 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\" = 'MO' 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 ('2072714'))
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" = 'MO' 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 ('2072714'))
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 CHI05CA132Accident · No injuriesData collectionFinal reportCessna 182F · Osage Beach, MOThe pilot's improper flare and his inadequate recovery from the bounced landing which resulted in a hard landing. A factor associated with the accident was the improper landing flare.NTSB MKC86LA183Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, MOThe plt-in-command (PIC) rprtd that a normal apch & flare were made, but as the acft touched down, the left main gear collapsed. The acft then swerved off the rwy & came to rest on upsloping dirt terrain. Investigation revealed the left main landing gear…NTSB MKC85LA038Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Caruthersville, MOAccording to the plt, the eng lost power after takeoff as the acft was climbing thru about 400 to 500 ft AGL. He attempted to land straight ahead on the remaining rwy. However, he was unable to stop on the rwy. The acft continued off the end of the rwy, went…NTSB MKC83LA085Accident · No injuriesLimited investigationFinal reportCessna 182F · Concordia, MOThe acft was forced to land in a wheatfield when the engine quit. The student pilot was on a solo cross-country flight cruising at 2000 feet when the engine lost power. The flt. Had started about 30 minutes before the accident. The dew point was 32 and the…NTSB MKC80FA014Accident · 1 fatalClosedCessna 182S · Womack, MONTSB MKC76DCG24Accident · No injuriesClosedCessna 182F · Warrensburg, MONTSB MKC73DCG30Accident · No injuriesClosedCessna 182 · Lexington, MONTSB MKC68A0029Accident · 3 fatalClosedCessna 182F · Leopold, MONTSB MKC67A0048Accident · 1 fatalClosedCessna 182F · Sikeston, MONTSB MKC66D0089Accident · No injuriesClosedCessna 182 · Gravois Mills, MONTSB MKC65A0078Accident · No injuriesClosedCessna 182 · St.Louis, MONTSB MKC65D0135Accident · No injuriesClosedCessna 182 · Columbia, MO