NTSB investigations: Continental IO-520 series

160 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of control - in flight”. 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 ('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\" = 250))
  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.

NTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.Mar 15, 2001 · N210HS · Substantial damageNTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.Feb 26, 2001 · N4637M · DestroyedNTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.Feb 19, 2001 · N7703R · DestroyedNTSB CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.Oct 19, 2000 · N782B · DestroyedNTSB CHI00LA094Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hayti, MOthe failure of maintenance personnel to properly install and connect the aileron control rod. Factors were the inadequate annual inspection by maintenance personnel and the aileron control not possible by the pilot.Mar 21, 2000 · N4859Q · Substantial damageNTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…Mar 10, 2000 · N311JR · Substantial damageNTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.Feb 14, 2000 · N875JC · DestroyedNTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.Feb 12, 2000 · N8425Q · Substantial damageNTSB LAX00LA095Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Glendale, AZthe pilot's attempt to go-around with inadequate altitude and airspeed available, resulting in a power demand that exceeded the capability of the aircraft. The fully extended gear and flaps were factors in this accident.Feb 8, 2000 · N4946U · Substantial damageNTSB ATL99LA101Accident · No injuriesLimited investigationFinal reportCessna A188B · Glen Allan, MSThe improper installation of a nut and bolt assembly by a maintenance personnel that resulted in the in-flight loss of control of the left ailiron.Jun 19, 1999 · N53198 · Substantial damageNTSB NYC98LA151Accident · No injuriesLimited investigationFinal reportCessna A185F · Moneta, VAThe pilot's failure to maintain airspeed which resulted in a stall and subsequent collision with water.Jul 18, 1998 · N1481F · Substantial damageNTSB FTW98FA192Accident · 3 fatalField investigationFinal reportBeech BE-58 · Kerrville, TXThe non-instrument rated pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the dark night conditions, overcast skies, and the pilot's inadequate preflight planning.Apr 26, 1998 · N60UU · DestroyedNTSB NYC98LA052Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Lancaster, PAPassenger control interference which resulted in pilot's failure to maintain control of the airplane during landing.Dec 24, 1997 · N4133S · Substantial damageNTSB SEA97LA143Accident · No injuriesLimited investigationFinal reportCessna A188 · Richland, WAthe pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.Jun 17, 1997 · N9766V · Substantial damageNTSB CHI97LA040Accident · No injuriesLimited investigationFinal reportBeech B55 · Park Rapids, MNthe pilot's high flare. Factors were the icing weather condition and the airframe ice.Dec 6, 1996 · N17732 · Substantial damageNTSB LAX97FA049Accident · 1 fatalField investigationFinal reportBeech 95-C55 · San Diego, CAthe pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…Nov 22, 1996 · N3774Q · DestroyedNTSB MIA97LA001Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Jackson, MSthe pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.Oct 2, 1996 · N4178S · Substantial damageNTSB ANC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.Sep 3, 1996 · N1801Q · Substantial damageNTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.Aug 7, 1996 · N92917 · Substantial damageNTSB FTW96FA120Accident · 1 fatalField investigationFinal reportBeech A36 · Katy, TXa loss of control due to pilot incapacitation for undetermined reasons. A factor related to the pilot's injuries was the lack of shoulder harness restraint.Feb 20, 1996 · N2TC · Substantial damageNTSB LAX96FA086Accident · 4 fatalField investigationFinal reportBeech V35B · Delano, CAFailure of the pilot to maintain control of the aircraft during an IFR circling approach. A factor relating to the accident was: the pilot's lack of instrument flight experience in high performance aircraft.Dec 30, 1995 · N7337R · DestroyedNTSB CHI96LA047Accident · No injuriesLimited investigationFinal reportCessna 310R · Michigan City, INthe pilot-in-command's selecting and maintaining an improper approach speed.Nov 28, 1995 · N5CX · Substantial damageNTSB MIA96LA029Accident · 2 fatalLimited investigationFinal reportBellanca BL-17-30A · Kings Bay, GAa loss of control due to pilot spatial disorientation. Contributing to the accident was: the dark night condition and the pilot's improper decision to turn to an easterly heading with no ground reference lights available.Nov 25, 1995 · N28049 · DestroyedNTSB NYC96FA027Accident · 1 fatalField investigationFinal reportBeech A36 · Atlantic City, NJthe pilot's failure to maintain control of the airplane. A factor was the pilot's diverted attention due to an open aft cargo door.Nov 23, 1995 · N550RR · DestroyedNTSB LAX96FA042Accident · 4 fatalField investigationFinal reportBeech S35 · Kneeland, CAfailure of the pilot to correct a descending spiral and perform a missed approach, after becoming spatially disoriented and deviating from the planned ILS approach procedure. Factors relating to the accident were: darkness, and the pilot's excessive…Nov 9, 1995 · N8920M · DestroyedNTSB LAX96LA024Accident · No injuriesLimited investigationFinal reportCessna 206 · Long Beach, CAthe failure of the pilot to maintain control of the aircraft while maneuvering by visual reference to the surface in IFR conditions. An additional factor was the pilot's failure to continue with the missed approach.Oct 27, 1995 · N2167F · Substantial damageNTSB LAX95GA334Accident · 2 fatalFinal reportCessna U206G · Dos Palos, CAthe pilot-in-command's failure to assure that adequate airspeed was maintained.Sep 12, 1995 · N6355U · DestroyedNTSB CHI95LA279Accident · No injuriesLimited investigationFinal reportCessna 188B · Canton, KSfailure of the pilot to obtain the proper flying speed or to abort the takeoff, while there was sufficient runway remaining, which resulted in an inadvertent stall.Aug 14, 1995 · N9151R · Substantial damageNTSB CHI95LA241Accident · No injuriesLimited investigationFinal reportCessna 188 · Bremen, NDthe pilot's inadequate preflight planning. Deteriating aircraft performance was a factor.Jul 29, 1995 · N9980G · DestroyedNTSB FTW95LA193Accident · No injuriesLimited investigationFinal reportBeech F33A · Houston, TXThe pilot's inadequate compensation for the wind conditions. A factor was the crosswind.May 7, 1995 · N18413 · Substantial damageNTSB LAX95LA118Accident · No injuriesLimited investigationFinal reportCessna A-188B · Elmira, CAthe pilot's failure to maintain control of the aircraft after an inadvertent encounter with the wake turbulence from a preceding agricultural aircraft while maneuvering at low altitude.Feb 23, 1995 · N731CZ · Substantial damageNTSB FTW95LA073Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Erie, COThe pilot's failure to maintain airspeed resulting in the inadvertent stall.Dec 23, 1994 · N8389Q · Substantial damageNTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.Aug 30, 1994 · N4811R · Substantial damageNTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.Jul 7, 1994 · N107JT · DestroyedNTSB CHI94FA157Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Camdenton, MOThe pilot's failure to maintain control of the aircraft. A factor was his lack of experience flying in actual instrument flight conditions.May 14, 1994 · N4226B · DestroyedNTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.Oct 22, 1993 · N8688Q · DestroyedNTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.Oct 9, 1993 · N6AP · DestroyedNTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.Sep 2, 1993 · N21861 · DestroyedNTSB LAX93LA252Accident · No injuriesLimited investigationFinal reportCessna 210L · Douglas, AZThe pilot's premature retraction of the landing gear and flaps at a critical time in the takeoff initial climb and his failure to attain an adequate climb airspeed which resulted in an inadvertent stall/mush condition. A factor in the accident was the high…Jun 13, 1993 · N29133 · Substantial damageNTSB LAX93FA186Accident · 2 fatalField investigationFinal reportBeech 58 · Tucson, AZThe pilots improper preflight inspection, his failure to compeltely secure the aft utility door, and his failure to reconfigure the trim tabs to a takeoff setting. The utility door's sudden opening just after rotation and the effect of the nose up trim…Apr 26, 1993 · N158WB · DestroyedNTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.Oct 19, 1992 · N2141S · Substantial damageNTSB MIA93LA003Accident · 2 fatalLimited investigationFinal reportMcilraith Steen Skybolt · Hattiesburg, MSA loss of control for undetermined reasons.Oct 4, 1992 · N2GM · Substantial damageNTSB NYC92LA138Accident · No injuriesLimited investigationFinal reportBeech 58 · West Chester, PAAn encounter with windshear which resulted in the airplane landing hard and short of the runway. A factor related to the accident was the gusty wind conditions.Aug 1, 1992 · N38CL · Substantial damageNTSB CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.Jul 29, 1992 · N4573F · Substantial damageNTSB CHI92DEC01Accident · No injuriesFinal reportCessna 188A · Imlay City, MIThe pilot induced premature liftoff which resulted in inadequate airspeed and the resulting stall.May 19, 1992 · N9946G · DestroyedNTSB ANC92LA057Accident · No injuriesLimited investigationFinal reportCessna U206G · Kotzebue, AKThe pilot's failure to remove all the frost from the airplane and exceeding the gross weight limit of the airplane.Apr 2, 1992 · N9909Z · Substantial damageNTSB LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.Mar 14, 1992 · N53241 · DestroyedNTSB CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.Mar 11, 1992 · N1328G · DestroyedNTSB ANC92LA007Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Scammon Bay, AKThe pilot's failure to maintain airspeed during the aborted landing. Contributing to the accident was the unfavorable wind.Oct 18, 1991 · N7353Q · Substantial damageNTSB ANC91LA131Accident · No injuriesLimited investigationFinal reportCessna 206 · Funnel Lake, AKThe pilot's failure to attain proper airspeed. Contributing to the accident was the high wind encountered during takeoff and the terrain.Aug 22, 1991 · N5209X · Substantial damage