NTSB investigations: Continental GTSIO-520-C, MI
6 cases on aircraft whose registry engine model is Continental GTSIO-520-C. 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
| 1970 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 1996 | 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\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035'))
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" = 'MI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035'))
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 CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB CHI96LA028Accident · No injuriesLimited investigationFinal reportCessna 421 · Romeo, MIthe failure of the pilot to maintain sufficient airspeed during landing, causing the inadvertent stall. A factor was the icing conditions.NTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…NTSB CHI80FEM06Accident · No injuriesClosedCessna 402A · Lansing, MINTSB CHI78FEC43Accident · No injuriesClosedCessna 402 · Salem, MINTSB CHI70FBJ08Accident · No injuriesClosedCessna 411 · Negaunee, MI