NTSB investigations: Cessna 177RG, NJ

8 cases on aircraft the registry lists as Cessna 177RG. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

NTSB investigations: Cessna 177RG, NJ per year, 1974–2026: 8 cases
1974	1
1975	1
1980	2
1996	1
2000	1
2002	1
2007	1

Where

Open the map

Latest cases

Query with SQL

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 ('2073709', '2073710')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073709', '2073710'))
  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 ('2073709', '2073710'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC07LA063Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pedricktown, NJThe first pilot's inadequate preflight inspection, and water contamination of the airplane's fuel system. A factor contributing to the accident was rough/uneven terrain.Jul 6, 2007 · N52650 · Substantial damage NTSB IAD02LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Trenton, NJThe separation of the engine induction alternate air door, which resulted in a loss of engine power. A factor was the non-compliance with the manufacturer's service letter.May 31, 2002 · N8200G · Substantial damage NTSB NYC00LA253Accident · No injuriesLimited investigationFinal reportCessna 177RG · Elmer, NJThe instructor's failure to take remedial action.Sep 7, 2000 · N2156Q · Substantial damage NTSB NYC96LA147Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Rockaway, NJThe pilot's impairment of judgment and performance due to alcohol which led to his inadequate preflight of the aircraft and his inadequate inflight decision which resulted in fuel exhaustion and loss of engine power.Jul 12, 1996 · N8059G · Substantial damage NTSB NYC81FHD07Accident · Serious injuriesClosedCessna 177RG · Vineland, NJNov 7, 1980 · N610QR · Destroyed NTSB NYC80FHD11Accident · No injuriesClosedCessna 177RG · Normandy Beach, NJMay 20, 1980 · N2190Q · Substantial damage NTSB NYC76AN062Accident · 2 fatalClosedCessna 150M · Buena, NJDec 28, 1975 · N2928V · 2 aircraft · Destroyed NTSB NYC74AN075Accident · 1 fatalClosedCessna 177 · Lambertville, NJMar 3, 1974 · N1985Q · Destroyed