NTSB investigations: Continental O-470 series, 1985
10 cases on aircraft whose registry engine model is Continental O-470 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 | 6 |
|---|---|
| 1983 | 9 |
| 1984 | 10 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 5 |
| 1989 | 8 |
| 1990 | 2 |
| 1991 | 6 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 5 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 7 |
| 2005 | 5 |
| 2006 | 2 |
| 2007 | 4 |
Where
Latest 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 ('17026')
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 ('17026')
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 DEN86FA038Accident · 2 fatalField investigationFinal reportCessna C-182 · Gallup, NMThe plt departed las cruces, NM, on a VFR flt to Gallup,NM. Approx 23 miles from destination, in mountainous terrain, the non-instrument rated plt encountered unforecast snow storm conditons at night. While the plt was maneuvering toward the destination at a…NTSB NYC86LA036Accident · No injuriesLimited investigationFinal reportCessna C182 · Gardiner, NYThe acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.…NTSB ATL86FA025Accident · 2 fatalField investigationFinal reportCessna 182Q · Edenton, NCThe aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated…NTSB FTW86FA011Accident · 2 fatalField investigationFinal reportCessna 180 · Cisco, TXNon-instrument rated pvt pilot proceeded into instrument weather conditions. Control was lost and the aircraft impacted steep nose down in city limits. No record of a wx briefing being received by the pilot was found. No evidence of pre- impact failure or…NTSB DEN86FA009Accident · 4 fatalField investigationFinal reportCessna 180 · Eagle, COThe plt departed Eagle arpt with 3 pax to fly them to the white owl lake area for the reported purpose of looking for a possible camping site for hunting activities. The plt encountered IMC and lost control of the acft. He was not instrument rated. All…NTSB DEN85FA203Accident · 2 fatalField investigationFinal reportCessna C-182 · La Salle, COThe plt and his girlfriend t/o from a pvt airfield north of denver co in a C182 in heavy fog conditions. The pilot was not inst rated. Shortly after t/o the aircraft hit the ground and was destroyed. Both occupants rec'd fatal injuries.NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB ATL85FA113Accident · 2 fatalField investigationFinal reportCessna 182 · Le Banon, VAThe acft impacted trees and came to rest 400 ft downslope from the top of clinch mountain. The non-instrument rated plt departed sprinfield, MO, with a ceiling of aprx 300-400 ft AGL. The plt then landed at cookeville, TN, where he received a wx briefing and…NTSB FTW85LA098Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Abilene, TXDeteriorating wx was encountered & the plt elected to land short of the original destn. He was provided vectors for an ILS apch to rwy 35R at abiline, TX. During the night apch, he encountered strong gusty winds, severe turbulence & restricted visibility. The…NTSB MKC85LA043Accident · No injuriesLimited investigationFinal reportCessna 182P · Ellisonore, MOPlt obtained wx briefing for route from moline, IL, st. louis, MO, memphis, TX, to new orleans, LA. Plt was informed vfrwas not recommended in eastern Iowa but st. louis was VFR and forecast to be 1000 to 2000 ft broken to scattered all morning. VFR was also…