NTSB investigations: Cessna 182L, FL
12 cases on aircraft the registry lists as Cessna 182L. 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
| 1968 | 3 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 2 |
| 2002 | 1 |
| 2011 | 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\" = 'FL' 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 ('2072726'))
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" = 'FL' 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 ('2072726'))
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 ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.NTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.NTSB MIA75DLD45Accident · Minor injuriesClosedCessna 182L · Summerfield, FLNTSB MIA75DKT45Accident · No injuriesClosedCessna 182L · Ft Lauderdale, FLNTSB MIA72DLD58Accident · No injuriesClosedCessna 182L · Cedar Key, FLNTSB MIA72DKT04Accident · No injuriesClosedCessna 182 · Hollywood, FLNTSB MIA71DLD57Accident · No injuriesClosedCessna 182 · Sarasota, FLNTSB MIA71DLD36Accident · No injuriesClosedCessna 182 · Leesburg, FLNTSB MIA69F0457Accident · No injuriesClosedCessna 182L · Fernandna Bch, FLNTSB MIA69D0258Accident · No injuriesClosedCessna 182 · Silver Spring, FLNTSB MIA69D0287Accident · No injuriesClosedCessna 182 · Jacksonville, FLNTSB MIA69D0131Accident · No injuriesClosedCessna 182L · Jacksonville, FL