NTSB investigations: Continental C90 series, 1987
16 cases on aircraft whose registry engine model is Continental C90 series. 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
| 1964 | 78 |
|---|---|
| 1965 | 82 |
| 1966 | 79 |
| 1967 | 63 |
| 1968 | 49 |
| 1969 | 43 |
| 1970 | 38 |
| 1971 | 32 |
| 1972 | 37 |
| 1973 | 33 |
| 1974 | 30 |
| 1975 | 22 |
| 1976 | 17 |
| 1977 | 27 |
| 1978 | 19 |
| 1979 | 14 |
| 1980 | 16 |
| 1981 | 9 |
| 1982 | 15 |
| 1983 | 7 |
| 1984 | 16 |
| 1985 | 8 |
| 1986 | 15 |
| 1987 | 16 |
| 1988 | 13 |
| 1989 | 14 |
| 1990 | 11 |
| 1991 | 16 |
| 1992 | 7 |
| 1993 | 14 |
| 1994 | 9 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 9 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 12 |
| 2005 | 8 |
| 2006 | 8 |
| 2007 | 5 |
| 2008 | 8 |
| 2009 | 10 |
| 2010 | 13 |
| 2011 | 11 |
| 2012 | 11 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 11 |
| 2020 | 8 |
| 2021 | 8 |
| 2022 | 7 |
| 2023 | 8 |
| 2024 | 4 |
| 2025 | 8 |
| 2026 | 9 |
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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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 MIA88LA062Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Ocoee, FLThe plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he…NTSB LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…NTSB ATL87LA263Accident · No injuriesLimited investigationFinal reportCessna 140 · Jesup, GADuring initial takeoff the aircraft's engine lost power and the aircraft collided with the ground. Investigation revealed the carburetor inlet filter was 50 percent plugged with rusty material and two tablespoons of rusty water remained in the carburetor…NTSB SEA87LA174Accident · 1 fatalLimited investigationFinal reportLutz Flying Dutchman · Twin Falls, IDThe purpose of the flt was to check the acft after replacing a wooden prop with an all metal prop & to prepare for entry in the reno air races. Bfr entering the air races. The plt needed to demonstrate his ability to make a 'barrel roll' & to make 3 lndgs.…NTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.NTSB CHI87LA182Accident · No injuriesLimited investigationFinal reportPiper J3 · Vermillion Lake, MNWhile attempting to return to land after the loss of power, the right wing tip hit the water and the aircraft flipped upside down into the lake. According to a mechanic who inspected the aircraft after the accident, the coils and condensers on both magnetos…NTSB ANC87FA112Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKTwo certificated flight instructors intended to practice landings in a tail wheel airplane. Shortly after the first take off, the PIC stated that there was an abrupt loss of power. The airplane was unable to return to the airport and crashed on a residential…NTSB SEA87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-11 · The Dalles, ORThe pilot was at 50 feet AGL on final approach to land at his private airstrip when he lost control. Reportedly, a gust of wind turned the aircraft 180 degrees. The aircraft descended and struck trees and the ground. Winds were reported variable at 40 to 45…NTSB CHI87LA165Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Lake Monroe, INThe float equipped acft took off from Lake Monroe with 2 rated plts on board. The plt-in-command (PIC) stated that the takeoff distance may have been about 20% longer than normal. He said that after climbing about 200 to 250 ft, the coplt began a rgt turn,…NTSB ANC87LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Mcneil Cove, AKThe pilot and his passenger were flying at approximately 150 feet above the water near the shoreline when the pilot made a steep left climbing turn. The airplane stalled and crashed into the water. The pilot was not rated to fly seaplanes. No mechanical…NTSB CHI87LA138Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Inver Grove Hts, MNAfter a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.NTSB MIA87FA150Accident · 1 fatalField investigationFinal reportPiper PA-11 · Hollandale, MSWitnesses stated that the acft circled a pond & dived once, then on a 2nd circling attempt, it made a short steep turn & went into a twisting dive into the pond. The passenger stated that they were flying at appx 100 to 150 ft above some fish ponds when the…NTSB CHI87LA080Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Big Fork, MNAfter several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…NTSB ANC87FA031Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe pilot-in-command accomplished unauthorized repairs to his airplane after an incident four days earlier. He repaired the right main landing gear by using a common door hinge to attach it to the fuselage. Upon landing, the door hinge failed and control of…NTSB ANC87FA033Accident · No injuriesField investigationFinal reportChampion 7EC · Kenai, AKThe pilot allowed the wing tip to descend into brush and willows while turning to avoid obscured sky conditions. The turn was downwind and the airplane stalled and struck the snow while skidding sideways.NTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…