NTSB investigations: Cessna 175, 1984
8 cases on aircraft the registry lists as Cessna 175. 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
| 1964 | 20 |
|---|---|
| 1965 | 27 |
| 1966 | 26 |
| 1967 | 21 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 9 |
| 1971 | 18 |
| 1972 | 10 |
| 1973 | 14 |
| 1974 | 11 |
| 1975 | 9 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 6 |
| 1979 | 8 |
| 1980 | 7 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 8 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 8 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 5 |
| 1994 | 7 |
| 1995 | 8 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 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 year(c.\"eventDate\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502'))
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 FTW85LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Bastrop, LAPlt stated that on preflight a small amount of water was drained from each wing tank. Also, the main fuel strainer was drained and fuel tanks were topped off (17 gals added). At about 500 ft AGL on initial climb, the engine quit and restart attempts were…NTSB SEA85LA033Accident · No injuriesLimited investigationFinal reportCessna 175 · Indian Meadows, IDLanded long and acft slid off end of rwy on compact snow and ice contacting a snow berm near end of rwy.NTSB SEA85LA003Accident · No injuriesLimited investigationFinal reportCessna 175 · Astoria, ORThe plt reported that during landing the acft started to skid to the left of the rwy. He applied rudder and aileron and then added power. The elevator was pulled back, the nose went up and the left wing went down. The acft hit the ground hard on the wing tip…NTSB DEN84LA302Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Corona, NMAt 0809 hrs, plt obtained telephone weather briefing & was advised VFR flt not recommended for intended route. At 1310 hrs, plt obtained second briefing, VFR flight again not recommended, no improvement expected prior to noon of following day. At 1428 hrs plt…NTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…NTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.NTSB NYC84LA179Accident · No injuriesLimited investigationFinal reportCessna 175 · Ticonderoga, NYA student plt performing touch and go landings observed another acft at the departure end of the rwy, facing him. Assuming a collision was immenent, the plt aborted the takeoff, but locked the brakes while trying to stop. The acft swerved off the rwy, the…NTSB DEN84LA112Accident · No injuriesLimited investigationFinal reportCessna 175 · Ogden, UTAfter takeoff, the eng began to smoke & lose power. During a forced landing in a muddy plowed field, the acft nosed over. A compression check was accomplished & the #5 cylinder was found to have zero compression. The cylinder was removed & found to be cracked…