Skip to content

NTSB investigations · 23

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2072508') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2072508')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072508')
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 CEN17LA060Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Millersburg, OHThe pilot's improper in-flight fuel management and his failure to switch the fuel selector to the “both” position in accordance with the Before Landing checklist, which resulted in a loss of engine power due to fuel starvation.Dec 21, 2016 · N8381T · Substantial damage NTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.Oct 8, 2010 · N8323T · Substantial damage NTSB SEA02FA009Accident · 1 fatalField investigationFinal reportCessna 175C · Miles City, MTThe separation of the number four cylinder exhaust valve guide from the cylinder head, leading to the failure of the exhaust valve stem and the catastrophic failure of the engine while in cruise flight. Factors include the necessity of attempting a forced…Nov 5, 2001 · N8347T · Substantial damage NTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.Aug 15, 1998 · N8512X · Substantial damage NTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.Jun 20, 1988 · N8371T · Destroyed NTSB LAX88LA200Accident · Serious injuriesLimited investigationFinal reportCessna 175C · Santa Rosa, CAMay 27, 1988 · N8384T · Substantial damage NTSB MKC87LA141Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Bear Creek, MODuring a personal xc flt, plt experienced a partial loss of power followed by a total loss of power. During emergency ldg, pilot stated that he prematurely added full flaps, which resulted in too steep of a descent, causing acft to be short of intended…Jul 18, 1987 · N8326T · Substantial damage NTSB OAK78FXQ37Accident · No injuriesClosedCessna 175 · Winnemucca, NVJul 23, 1978 · N8386T · Substantial damage NTSB FTW74DPJ08Accident · No injuriesClosedCessna 175C · Hollis, LASep 2, 1973 · N8369T · Substantial damage NTSB SEA74AS004Accident · 2 fatalClosedCessna 175C · Pacific City, ORJul 24, 1973 · N8318T · Destroyed NTSB OAK73FVW02Accident · 1 fatalClosedCessna 175C · Independnce, CAJul 4, 1972 · N8396T · Destroyed NTSB FTW70D0126Accident · No injuriesClosedCessna 175 · Hitchcock, TXJul 21, 1969 · N8330T · Substantial damage NTSB FTW70F0116Accident · No injuriesClosedCessna 175 · Oklahoma Cty, OKJul 20, 1969 · N8304T · Substantial damage NTSB CHI70F0043Accident · No injuriesClosedCessna 175C · Berlin Centr, OHApr 17, 1969 · N8309T · Substantial damage NTSB NYC67F0303Accident · Minor injuriesClosedCessna 175C · Alton, VASep 24, 1966 · N8316T · Substantial damage NTSB NYC67D0026Accident · No injuriesClosedCessna 175 · Madison, CTJul 3, 1966 · N8395T · Substantial damage NTSB FTW66F0649Accident · No injuriesClosedCessna 175C · Rosharon, TXMay 1, 1966 · N8330T · Substantial damage NTSB MKC66D0230Accident · No injuriesClosedCessna 175 · Boone, IASep 26, 1965 · N8372T · Substantial damage NTSB OAK66D0087Accident · 3 fatalClosedCessna 175 · 90s Oahu, HIAug 18, 1965 · N8378T · Destroyed NTSB UNK64X3952Accident · 1 fatalClosedCessna 175 · Quakertown, PASep 13, 1964 · N8382T · Destroyed NTSB UNK64X2130Accident · No injuriesClosedCessna 175 · Okla City, OKJun 5, 1964 · N8369T · Substantial damage NTSB UNK64X1918Accident · No injuriesClosedCessna 175 · Brunswick, GAMay 23, 1964 · N8341T · Substantial damage NTSB UNK64X0627Accident · Serious injuriesClosedCessna 175 · Fire Is, AKFeb 20, 1964 · N8313T · Destroyed

Back to Cessna 175C