NTSB investigations: Cessna 182L, 1982
4 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
| 1967 | 1 |
|---|---|
| 1968 | 29 |
| 1969 | 25 |
| 1970 | 22 |
| 1971 | 14 |
| 1972 | 8 |
| 1973 | 8 |
| 1974 | 14 |
| 1975 | 10 |
| 1976 | 11 |
| 1977 | 3 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 6 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1998 | 3 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 3 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 3 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 1 |
| 2025 | 2 |
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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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 FTW83FRG04Accident · 2 fatalFinal reportCessna 182L · Near Mcallen, TXThe aircraft departed Mcallen, TX at 1903 CST to an unknown destination. During departure, it was observed heading northwest. About 1 1/2 hrs later, it was again observed in the vicinity, about 7 miles northwest of Mcallen, TX. Witnesses stated that the plane…NTSB LAX82FA231Accident · 2 fatalField investigationFinal reportCessna 182 · Truckee, CAAt aprx 2015 PDT on 6/13/82, the acft departed petaluma, CA on a ngt, VFR, x-country flt to riverton, WY. An en route stop was planned for elco, NV. No records were fnd of a wx briefing or flt plan. The acft was declared overdue on 6/16/82 & the wreckage was…NTSB FTW82FRJ09Accident · Serious injuriesFinal reportCessna 182L · Farmerville, LAThe pilot reported that his takeoff and climb to 2200 ft MSL were normal. After the plane was in cruise configuration, he heard an abnormal noise and decided to return to the airport. The noise level increased and the engine began to vibrate. The pilot…NTSB ATL82DA045Accident · No injuriesFinal reportCessna 182L · Conyers, GAThe destination airport is a private strip that is oriented on a 150/330 degree heading. The northwest end is enclosed by tall trees. Accordingly, most landings are made toward the northwest regardless of wind direction. The pilot landed on runway 33 which…