NTSB investigations: Continental C90 series
1,117 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, newest first
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.\"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 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 NYC92LA019Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Manchester, VTThe pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.NTSB MIA91LA228Accident · Serious injuriesLimited investigationFinal reportAeronca 7EC · Moore Haven, FLThe pilot's diversion of attention and inattention to the airspeed resulting in the inadvertent stall mush. Contributing to the accident was inadequate altitude to recover.NTSB LAX91LA397Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Phoenix, AZThe pilot's improper remedial action. Contributing to this accident was the pilot's improper use of the brakes and rudder and his lack of experience in the accident airplane's make and model.NTSB NYC91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Eagle Lake, METhe pilot's misjudgment of his altitude during a landing on glassy water, which resulted in a loss of airplane control.NTSB CHI91LA240Accident · No injuriesLimited investigationFinal reportPiper J-3 · Saint Leo, MNPerformance data was misjudged resulting in a positive climb not being attained by the pilot. A factor related to the accident was high density altitude.NTSB ANC91LA101Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chataniak Vly, AKPartial loss of engine power for an undetermined reason.NTSB LAX91LA290Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Trinity Center, CAThe pilot's failure to ensure an adequate supply of fuel was available. Contributing to this accident was soft terrain.NTSB FTW91LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Clinton, ARThe loss of directional control due to locked wheel brake on the left landing gear.NTSB FTW91LA099Accident · No injuriesLimited investigationFinal reportChampion 7FC · Medina, TXThe pilot's inadequate visual lookout.NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.NTSB CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.NTSB CHI91LA145Accident · No injuriesLimited investigationFinal reportAeronca 7EC · O'Neill, NEThe pilot's selection of unsuitable terrain for a precautionary landing. Factors were the pilot's disregarding the weather briefing and his intentional flight into adverse weather.NTSB SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.NTSB ATL90LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Midfield, ALThe pilot's inadequate assessment of deteriorating weather conditions and his resultant flight into areas of low clouds. The safety board believes that the pilot's overall lack of experience was a factor in the accident.NTSB FTW90LA180Accident · No injuriesLimited investigationFinal reportMooney M-10 · Roscoe, TXThe pilot's loss of directional control. A factor was: rough/uneven terrain.NTSB CHI90LA259Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lebanon, ILthe loss of engine power for undetermined reasons while executing a go-around with insufficient runway remaining for a forced landing. A factor in the accident was the structures at the end of the runway that the pilot was attempting to avoid. This report was…NTSB CHI90LA150Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hillsboro, OHFailure of the pilot to maintain directional control during initial climb after takeoff. The pilot's lack of experience in the airplane is a factor.NTSB ATL90LA131Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7CCM · Albany, GAFailure of the pilot in command to directional control on takeoff initial climb, and failure to maintain a visual lookout for obstacles.NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.NTSB NYC90LA113Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rumford, METhe pilot made a steep turn to avoid the shore line and inadvertently stalled. Factors related to the accident were: the pilots decision to takeoff with a canoe strapped to one of the floats and his lack of experience in carrying a canoe on the floats.NTSB DEN90LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Morgan, UTPilot's improper use of the brakes during landing roll.NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB ANC90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-11 · King Salmon, AKPilot-in-command's failure to maintain airplane control.NTSB SEA90LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAEngine loss of power was due to moisture damage to the coils in the magnetoes. During the forced landing in an open field, the airplane collided with a fence which resulted in substantial damage. The airplane had not undergone current maintenance inspections…NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB ANC89LA180Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork, AKImproper planning/decision by the pilot.NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB ANC89FA143Accident · No injuriesField investigationFinal reportPiper PA-19 · Anchorage, AKOperation with a known deficiency in the aircraft and water contamination of the fuel due to inadequate preflight preparation by the pilot. Factors related to the accident were: lack of suitable terrain for a forced landing and tree(s).NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.NTSB ANC89LA135Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kodiak, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB ANC89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-100 · Knik River, AKThe failure of the pilot-in-command to maintain control of the airplane on the ground by proper use of the flight controls during gusting winds.NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.NTSB MKC89LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ramsey, MNThe passengers interference with the flight controls and the pilot's failure to maintain control of the aircraft. Contributing to the severity of the accident was the ditch located short of the runway which the aircraft contacted.NTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.NTSB DEN89LA125Accident · No injuriesLimited investigationFinal reportChampion 7EC · St George, UTInadequate compensation for the wind conditions by the pilot. The gusty crosswind, soft terrain, and ditch were contributing factors.NTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.NTSB LAX89FA099Accident · 1 fatalField investigationFinal reportSilvaire 8F · Lake Elsinore, CALoss of aircraft control due to improper and/or unapproved modifications to the aircraft's aileron control system by the pilot/owner. A contributing factor was the pilot/owner's overconfidence in his ability to modify the aileron control system without…NTSB DEN89LA049Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Winnett, MTThe pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…NTSB LAX89LA033Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Hesperia, CAWitnesses rprtd that the winds at the arpt were out of the west at about 20 KTS with peak gusts of about 37 KTS. They stated the wind sock was indicating a direct x-wind with rwy 3/21 & that the plt initiated his takeoff on rwy 21. Witnesses rprtd that during…NTSB CHI89LA003Accident · No injuriesLimited investigationFinal reportChampion 7EC · Bainbridge, OHNTSB BFO88FA082Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Orange, VAPilot initiated lift off before flying speed was gained and as a result the aircraft had a loss of aerodynamic lift and stalled on the initial takeoff climb. The pilot's inadequate inflight decision and failure to abort the takeoff are contributing factors.NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…NTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…NTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…NTSB MKC88LA123Accident · No injuriesLimited investigationFinal reportAeronca 7EC · St. Charles, MOThe plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision.NTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…NTSB LAX88LA173Accident · No injuriesLimited investigationFinal reportChampion 7CCM · Cameron Park, CAWhile practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were…NTSB LAX88LA166Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mayer, AZ