NTSB investigations: Continental IO-360 series

692 cases on aircraft whose registry engine model is Continental IO-360 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 ('17025', '17045'))
  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 NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.Nov 21, 2007 · N108GD · Substantial damageNTSB DFW08CA021Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's improper recovery from a bounced landing.Oct 26, 2007 · N5181A · Substantial damageNTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.Oct 13, 2007 · N1261X · Substantial damageNTSB ANC07LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's failure to maintain clearance from trees while landing.Sep 28, 2007 · N758TG · Substantial damageNTSB CHI07CA292Accident · No injuriesData collectionFinal reportMaule M5-210C · Central City, NEThe pilot's improper compensation for the crosswind condition and his failure to maintain directional control during landing, which resulted in an inadvertent ground loop. A contributing factor was the crosswind.Sep 2, 2007 · N62063 · Substantial damageNTSB ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.Aug 18, 2007 · N869CD · Substantial damageNTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.Nov 8, 2006 · N2500S · DestroyedNTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…Sep 15, 2006 · N787SL · DestroyedNTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.Sep 2, 2006 · N1893M · DestroyedNTSB CHI06CA279Accident · No injuriesData collectionFinal reportMeyers MAC-145 · Manistique, MIThe pilot not verifying the landing gear selector position prior to starting the taxi.Aug 6, 2006 · N34360 · Substantial damageNTSB LAX06LA232Accident · Minor injuriesLimited investigationFinal reportCessna R172K II · HagatnaThe failure of the number four connecting rod during takeoff-initial climb.Jul 15, 2006 · N1209V · Substantial damageNTSB CHI06LA212Accident · No injuriesLimited investigationFinal reportCessna R172K · Grand Rapids, MNThe pilot's failure to maintain control of the airplane during the landing. A factor associated with the accident was the gusty tailwind that prevailed.Jul 9, 2006 · N736VM · Substantial damageNTSB DEN06CA077Accident · No injuriesData collectionFinal reportCessna R172E (T-41C) · Albuquerque, NMthe pilot's failure to maintain aircraft control. A contributing factor was the wind gust.May 17, 2006 · N7898N · Substantial damageNTSB NYC06CA103Accident · No injuriesData collectionFinal reportMaule M-5-210C · Linville, VAThe pilot's improper decision to depart with a tailwind.Apr 23, 2006 · N62015 · Substantial damageNTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Apr 7, 2006 · N142SF · Substantial damageNTSB MIA06WA076Accident · 4 fatalForeign investigationCessna R172K · Cambita Garabit, Dominican RepublicMar 29, 2006 · N323EP · DestroyedNTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.Mar 18, 2006 · N777YM · Substantial damageNTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…Jan 26, 2006 · N6612E · Substantial damageNTSB LAX06FA087Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Lancaster, CAThe student pilot's failure to maintain an adequate airspeed while maneuvering, and, the flight instructor's inadequate supervision of the flight. A factor in the accident was the strong tailwind encountered as the airplane turned from an upwind to a downwind…Jan 9, 2006 · N526CD · DestroyedNTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.Nov 18, 2005 · N5182Z · Substantial damageNTSB ATL05CA162Accident · Serious injuriesData collectionFinal reportPiper PA-34-200 · Greenville, ALThe loss of left engine power due to fuel system contamination and the pilot's failure to follow procedures and his improper use of the throttle and flight controls during the forced landing.Sep 16, 2005 · N287RR · Substantial damageNTSB ANC05CA131Accident · No injuriesData collectionFinal reportMaule M-5-210C · Fairbanks, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in a loss of control and subsequent collapse of the main landing gear. Factors associated with the accident were a crosswind, and a steep drop-off.Aug 29, 2005 · N51623 · Substantial damageNTSB NYC05CA132Accident · No injuriesData collectionFinal reportCessna R172E · Patuxent River, MDThe pilot's improper recovery from a bounced landing, resulting in a hard landing.Aug 10, 2005 · N7880N · Substantial damageNTSB NYC05LA131Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Farmingdale, NJA fire that originated at the right main landing gear brake caliper and piston, during taxi, which resulted in substantial damage to the airplane.Aug 7, 2005 · N915DJ · Substantial damageNTSB DFW05FA192Accident · 2 fatalField investigationFinal reportAero Commander 112 · Junction, TXThe pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.Jul 27, 2005 · N1029J · DestroyedNTSB LAX05LA216Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Mojave, CAthe pilot's encounter with a downdraft or wind shear during takeoff the initial climb.Jun 26, 2005 · N3BZ · Substantial damageNTSB ATL05CA100Accident · No injuriesData collectionFinal reportGoodyear GZ-20A · Coral Springs, FLThe pilot's inadequate in-flight planning/decision which resulted in an in-flight encounter with weather (thunderstorm outflow), and downdrafts, loss of control and subsequent collision with trees and transmission wires.Jun 16, 2005 · N1A · Substantial damageNTSB MIA05CA118Accident · No injuriesData collectionFinal reportHerbert O. Kellerman 173 RG · Venice, FLThe owner/pilot mechanic's inadequate maintenance inspection resulting in a partial loss of engine power due to a loose fuel line.Jun 7, 2005 · N27BK · Substantial damageNTSB ATL05CA092Accident · Minor injuriesData collectionFinal reportCessna 172 · Crossville, TNThe pilot's continued VFR flight into IMC conditions which resulted in an in-flight collision with trees. A related factor was the clouds.Jun 3, 2005 · N1202V · Substantial damageNTSB DFW05LA153Accident · No injuriesLimited investigationFinal reportParkwood Enterprises Glasair Super II-S · Los Fresnos, TXA blocked fuel line in the fuel tank, which resulted in a loss of engine power due to fuel starvation.Jun 2, 2005 · N1UH · Substantial damageNTSB IAD05LA055Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Oakland, MDThe pilot's delay in aborting the landing, which resulted in an inadvertent stall/mush into the trees. A factor in the accident was the tailwind.Apr 14, 2005 · N53548 · DestroyedNTSB MIA05CA092Accident · No injuriesData collectionFinal reportCessna 337 B · Ocala, FLThe pilot's improper landing flare during an aborted takeoff, which resulted in a hard landing and damage to the airplane.Apr 13, 2005 · N463DA · Substantial damageNTSB SEA05LA068Accident · 1 fatalLimited investigationFinal reportCessna T337E · Orcas Island, WAThe loss of power for undetermined reasons which resulted in a forced landing and impact with water.Mar 29, 2005 · N1711M · Substantial damageNTSB MIA05IA087Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLInadequate welding procedure by the manufacturer resulting in a poor weld of the nose landing gear and collapse of the nose landing gear during a porpoised landing.Mar 11, 2005 · N8160C · Minor damageNTSB DFW05CA061Accident · Minor injuriesData collectionFinal reportMaule M-4-210C · McAlister, OKThe loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…Jan 24, 2005 · N9866M · Substantial damageNTSB MIA05FA050Accident · 2 fatalField investigationFinal reportCessna T337G · Lakeland, FLThe pilot's operation of the airplane with known deficiencies in equipment related to pitch, an abrupt pitch-up during the initial climb after takeoff for undetermined reasons and the failure of the pilot to maintain airspeed (Vs) resulting in inadvertent…Jan 14, 2005 · N42WA · DestroyedNTSB ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.Dec 9, 2004 · N42SE · Substantial damageNTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…Nov 16, 2004 · N133JW · DestroyedNTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.Sep 15, 2004 · N3832U · DestroyedNTSB ATL04CA182Accident · No injuriesData collectionFinal reportMaule M4-210C · Gainesville, FLThe pilot-rated passenger's inadvertent interference with the flight controls during landing, which resulted in a loss of control and the airplane nosed over.Sep 10, 2004 · N270JM · Substantial damageNTSB LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…Sep 2, 2004 · N897TW · DestroyedNTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.Jun 16, 2004 · N63BB · DestroyedNTSB NYC04FA127Accident · 1 fatalField investigationFinal reportMooney M20J · Oxford, CTThe pilot's failure to maintain altitude/clearance during an instrument approach, which resulted in a collision with trees prior to the runway. Factors were nighttime conditions and cloud cover.May 24, 2004 · N5763W · Substantial damageNTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.Apr 19, 2004 · N8157J · DestroyedNTSB DEN04LA053Accident · No injuriesLimited investigationFinal reportCessna C172 · Broomfield, COthe pilot of the Maule's failure to maintain a visual lookout.Mar 26, 2004 · N5345G · 2 aircraft · Substantial damageNTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.Dec 13, 2003 · N4621T · Substantial damageNTSB DEN03LA140Accident · No injuriesLimited investigationFinal reportCessna 337F · Las Cruces, NMLack of adequate power from the rear engine for undetermined reasons and the pilot's failure to maintain aircraft control during take-off. A contributing factor to the accident was the low altitude.Aug 6, 2003 · N8921M · Substantial damageNTSB SEA03CA162Accident · No injuriesData collectionFinal reportCessna R172K · Idaho Falls, IDThe pilot's failure to see and avoid a parked aircraft while taxiing.Jul 17, 2003 · N758LW · Substantial damageNTSB SEA03LA137Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · Fish Haven, IDThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, an inadvertent raising of the flaps for unknown reasons, and low altitude were factors.Jul 12, 2003 · N27SJ · Substantial damageNTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.Jun 30, 2003 · N6216M · Substantial damage