NTSB investigations: Cessna R182, NJ
7 cases on aircraft the registry lists as Cessna R182. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2018 | 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\" = 'NJ' 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 ('2072734'))
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" = 'NJ' 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 ('2072734'))
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 GAA18CA556Accident · No injuriesData collectionFinal reportCessna R182 · Mount Holly, NJThe pilot’s failure to maintain lateral control of the airplane during landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB NYC07CA054Accident · No injuriesData collectionFinal reportCessna R182 · Hackettstown, NJThe pilot-in-command's delayed aborted takeoff, which resulted in a runway overrun and collision with terrain. A factor was the rocks off the end of the runway.NTSB NYC07LA020Accident · No injuriesLimited investigationFinal reportCessna 182RG · Toms River, NJThe private pilot's failure to attain the proper touchdown point, and the flight instructor's inadequate remedial action, which resulted in a landing short of the runway. A contributing factor was the gusty wind conditions.NTSB NYC91LA238Accident · No injuriesLimited investigationFinal reportCessna 182RG · Robbinsville, NJA detached heli coil from the number 6 cylinder, resulting in a loss of engine power and subsequent forced landing in a corn field.NTSB NYC88LA110Accident · No injuriesLimited investigationFinal reportCessna 182RG · Princeton, NJDuring landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again…NTSB NYC85FA110Accident · 2 fatalField investigationFinal reportCessna R182 · Hamilton Twnshp, NJThe plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared…NTSB NYC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182RG · Teterboro, NJAccording to the plt after about an hour and 10 min flight he returned for landing. During the landing roll the acft skidded off the rwy onto soft dirt damaging the propeller and right wing tip.