NTSB investigations: Cessna 175, FL
12 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 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 ('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 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 ('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 MIA92LA125Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Yulee, FLLoss of engine power due to undetermined reasons shortly after takeoff.NTSB MIA91LA064Accident · No injuriesLimited investigationFinal reportCessna 175 · Okeechobee, FLFailure of the right brake line at the caliper during the landing roll rendering the brakes ineffective. A factor was the pilot's misjudgement of wind direction.NTSB MIA89LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Starke, FLFlt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…NTSB MIA84LA008Accident · No injuriesLimited investigationFinal reportCessna 175 · Ft. Mccoy, FLAbout 10 min after departing ft Mccoy, FL, the plt realized he had forgotten his flt bag, so he returned to land at the airstrip. During the landing, the acft floated, & after touching down, there was insufficient rwy remaining to safely stop or go around.…NTSB MIA79DLD30Accident · No injuriesClosedCessna 175 · Clearwater, FLNTSB MIA78DKJ45Accident · No injuriesClosedCessna 175 · Pensacola, FLNTSB MIA76FKT86Accident · No injuriesClosedCessna 175 · W.Palm Beach, FLNTSB MIA74DLA27Accident · No injuriesClosedCessna 175 · Cherry Lake, FLNTSB MIA73DKT21Accident · Serious injuriesClosedCessna 175 · Miami, FLNTSB MIA73FKT08Accident · Serious injuriesClosedCessna 175 · Port Charlote, FLNTSB MIA68D0410Accident · No injuriesClosedCessna 175 · Boca Raton, FLNTSB MIA67D0124Accident · No injuriesClosedCessna 175 · Howey-In-Hill, FL