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 LAX84LA394Accident · Serious injuriesLimited investigationFinal reportExperimental Amateur Built OWL Racer · Oroville, CAThe Experimental/amateur built aircraft had just turned inbound for an exhibition race run when it experienced severe vibrations as the pilot applied full power. He headed for the runway and found that he could not control the engine with the throttle. He was…NTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.NTSB SEA84LA089Accident · No injuriesLimited investigationFinal reportFornaire F-1 · Everett, WAThe acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage.NTSB ATL84FMG03Accident · Minor injuriesFinal reportBowers FLY Baby 1A · New Bern, NCThe plt stated the acft lost lateral control during takeoff. He reduced power and landed the acft off the side of the rwy while maintaining directional control using the rudder. The acft stalled at about 20 ft AGL and was damaged during the hard landing.…NTSB ANC84FA044Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe acft swerved and collided with a snowbank during landing. The wind was calm and the rwy dry. After the collision the right landing gear collapsed.NTSB NYC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Hastings, NYThe acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…NTSB DEN84LA099Accident · No injuriesLimited investigationFinal reportChampion 7EC · Wall, SDThe acft crashed during a flight for the purpose of observing the plt's cattle. The plt stated he was 'making a steep left turn at about 75 feet and the bottom (left) wing flew into a wind shear on the downward side of a hill. The airplane slid to the left…NTSB FTW83LA403Accident · No injuriesLimited investigationFinal reportCessna 140 · Hitchcock, TXThe acft nosed over during takeoff. The flt said that the rwy was 50 ft wide but had been mowed only to a width of 20 ftthe plt allowed the acft to drift into the high grass alongside the rwy. The acft continued off the rwy and nosed over in tail grass.…NTSB LAX83LA379Accident · No injuriesLimited investigationFinal reportAlon A2 · Afton, CADuring an aerial observation mission, the passenger became ill, so the plt elected to land on a hard-packed strip across a plowed field. After landing, he walked over the area. Except for a rut at about midfield, he perceived there would be no problem in…NTSB NYC83LA181Accident · No injuriesLimited investigationFinal reportCessna 140 · Londonderry, VTThe plt reported that during a landing on rwy 23, the acft difted off the rwy when he did not allow for a x-wind. A go-around was initiated. However, the landing gear contacted a mound of dirt & the acft nosed over while it was at full throttle. Reportedly,…NTSB ANC83LA105Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Skwentna, AKThe pilot stated that he approached the river on final at 60 mph in a 5 degree bank to follow the curve of the water. When he dropped below trees at about 50 ft AGL the left wing stalled. He added full power and lowered the nose but the left wing hit the…NTSB ANC83LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Kasilof, AKThe acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several…NTSB NYC83LA112Accident · No injuriesLimited investigationFinal reportForney F-1 · Fitchburg, MAThe acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…NTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…NTSB ANC83LA026Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Near Palmer, AKImmediately after taking off from a frozen lake, the pilot turned left to parallel a fog bank over the knik river. He stated that while climbing, the engine did not quit, but the propeller lost thrust, and he lost control of the aircraft. He stated that he…NTSB FTW83LA036Accident · No injuriesLimited investigationFinal reportChampion 7FC · Alexandria, LADuring landing, the aircraft touched down with a right quartering tailwind. The pilot stated that after making a normal approach and landing, he overcontrolled the rudder. The aircraft veer off the runway and collided with a ditch before reaching the taxiway.…NTSB LAX83LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Oceanside, CAWhile attempting a touch and go from a wheel landing the pilot lost directional control and collided with a parked aircraft and a chain fence, finally nosing over. The pilot said he did not use enough right rudder during the roll. The parked aircraft, N5515B,…NTSB LAX83LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Wickenburg, AZThe pilot stated the aircraft touched the runway then ballooned during a wheels-first landing. After the pilot decided to execute a go-around and the aircraft became airborne, it became apparent that the aircraft could not clear rising terrain. The pilot cut…NTSB CHI82DA294Accident · No injuriesFinal reportBreezy RLU1 · Milwaukee, WIThe pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…NTSB FTW82DA305Accident · No injuriesFinal reportAlon A2 · Poyen, ARAs the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…NTSB DEN82DA124Accident · No injuriesFinal reportLuscombe 8F · Calhan, COThe pilot took off from an airport with a density altitude of about 9500 ft. after lift-off, the aircraft reached an altitude of about 100 ft AGL and then stopped climbing. The pilot initiated emergency procedures which included leaning the mixture and…NTSB ANC82DAG28Accident · 1 fatalFinal reportPiper PA-18 · Kenai, AKPilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.NTSB FTW82DA183Accident · No injuriesFinal reportChampion 7EC · Southlake, TXDuring takeoff, the private pilot sitting in the front seat, thought the cowling was loose. The pilot informed the owner and commercial pilot in the rear seat who took control and decided to return to the airport. The pilot landed short of the runway and the…NTSB LAX82DA173Accident · No injuriesFinal reportAeronca 7EC · Prescott, AZFollowing a wheel landing the aircraft bounced and made a three point landing. After crossing a runway intersection the aircraft developed a left turning tendency which the pilots stated they could not control. The aircraft ran into a ditch.NTSB FTW82DA180Accident · Minor injuriesFinal reportNash Cassutt Racer 111M · Sebastian, TXDuring cruise flight the engine misfired then quit and would not restart. The pilot made a forced landing in a grain field and the aircraft nosed over. No preimpact mechanical malfunction or failure was found.NTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.NTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.NTSB NYC82FNC04Accident · 1 fatalFinal reportAeronca 7EC · New Gloucester, METhe pilot flew the ski equipped aircraft to a frozen lake where he met two friends who were ice fishing. Later, after he visited with his friends and had given each of them a ride in the aircraft, the pilot took off again. After takeoff, the pilot turned back…NTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…NTSB LAX82DUM03Accident · No injuriesClosedCessna 140 · Barrett Lake, CANTSB FTW82DRG09Accident · No injuriesClosedCessna 140 · Charlotte, TXNTSB MIA81DLA36Accident · No injuriesClosedAeronca 7AC · Pnte Vdra Bch, FLNTSB CHI81FEC42Accident · No injuriesClosedBellanca 7FC · Ann Arbor, MINTSB MIA81FA107Accident · 2 fatalClosedPiper J5A · Carrabelle, FLNTSB FTW81DRA49Accident · No injuriesClosedAeronca 7EC · Laporte, TXNTSB LAX81FUJ75Accident · No injuriesClosedCessna 140 · Glendale, AZNTSB LAX81FA095Accident · 2 fatalClosedPiper PA-18 · Holtville, CANTSB SEA81DYM23Accident · No injuriesClosedCessna 140 · Pendleton, ORNTSB MIA81FA027Accident · 2 fatalClosedErco 415-C · Lakeland, FLNTSB ATL81FA019Accident · 5 fatalClosedPiper PA-32 · Hilton Head, SCNTSB MKC81DCQ03Accident · No injuriesClosedCassutt 3M · Liberal, KSNTSB ANC81DAG17Accident · Serious injuriesClosedPiper PA-11 · Kenai, AKNTSB CHI80FEE47Accident · 1 fatalClosedVari-Eze Heiman · Huntley, ILNTSB LAX80DVG69Accident · No injuriesClosedPiper J3C-65 · Montague, CANTSB NYC80FA075Accident · 1 fatalClosedPiper PA-18 · Exeter, RINTSB SEA80DYP32Accident · No injuriesClosedAeronca 7FC · Grangeville, IDNTSB MKC80DCQ28Accident · No injuriesClosedVarieze 01 · Dodge City, KSNTSB MKC80DCA25Accident · No injuriesClosedLuscombe 8F · Sullivan, MONTSB FTW80DPG47Accident · No injuriesClosedAeronca 7BCM · Bono, ARNTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, IN