NTSB investigations: Continental IO-520 series, 1985
4 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 7 |
|---|---|
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 6 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 9 |
| 2003 | 4 |
| 2004 | 8 |
| 2005 | 5 |
| 2006 | 7 |
| 2007 | 3 |
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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN86LA050Accident · Serious injuriesLimited investigationFinal reportBeech V-35B · Wibaux, MTThe plt stated that light snow was falling at the arpt at the time of departure. The pax stated after the accident that the plt encountered clouds at their cruise alt of about 6000 ft. he continued to state that the acft made a shallow descent at first…NTSB SEA85LA229Accident · No injuriesLimited investigationFinal reportCessna 185 · San Juan Island, WAThe pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid…NTSB ATL85LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Clanton, ALThe acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await…NTSB NYC85FHD02Accident · Serious injuriesFinal reportCessna 210F · Princeton, NJThe acft collided with trees & crashed after overflying mercer cty arpt on a special VFR clearance. The acft had descended to 900 ft to overfly mercer and was attempting to proceed VFR to Princeton arpt to land when it contacted trees and crashed. The wx was…