NTSB investigations, 2008

333 cases where the sequence of events included Loss of control in flight.

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 year(c.\"eventDate\") = 2008
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.Oct 1, 2008 · N2190W · Substantial damageNTSB ANC09FA001Accident · 2 fatalField investigationFinal reportCessna U206C · Anchorage, AKA loss of engine power during takeoff/initial climb for an undetermined reason, and the pilot's decision to make an abrupt and steep low altitude turn toward an intersecting runway, resulting in an aerodynamic stall and loss of aircraft control.Oct 1, 2008 · N29109 · DestroyedNTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.Sep 30, 2008 · N1012S · Substantial damageNTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.Sep 29, 2008 · N736LN · Substantial damageNTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.Sep 28, 2008 · N2504E · Substantial damageNTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.Sep 28, 2008 · N82TB · DestroyedNTSB DFW08FA237Accident · 2 fatalField investigationFinal reportCessna 320D · Collinsville, OKThe crews' failure to maintain adequate airspeed, which resulted in an aerodynamic stall close to the ground.Sep 28, 2008 · N4165T · Substantial damageNTSB DFW08CA239Accident · No injuriesData collectionFinal reportGier Travis H Aventura II · Montgomery, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the wind gust.Sep 28, 2008 · N92TG · Substantial damageNTSB SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.Sep 27, 2008 · N59611 · Substantial damageNTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.Sep 27, 2008 · N770CA · DestroyedNTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.Sep 27, 2008 · N1685 · Substantial damageNTSB LAX08WA305Accident · 1 fatalForeign investigationBell 206 · Douglas Camp, Papua New GuineaOn September 25, 2008, at 1012 local time, a Bell 206L3, Papua New Guinea (PNG) registry P2-HBC, crashed in a remote area near Douglas Camp (PNG) under unknown circumstances while reportedly performing long line operations. The helicopter was operated by Heli…Sep 25, 2008 · P2-HBC · Substantial damageNTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…Sep 24, 2008 · N926EL · Substantial damageNTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.Sep 24, 2008 · N602RN · DestroyedNTSB NYC08FA319Accident · 1 fatalField investigationFinal reportPiper PA-32 · Atlanta, GAA loss of aircraft control for undetermined reasons.Sep 23, 2008 · N3029Y · Substantial damageNTSB DFW08FA233Accident · 2 fatalField investigationFinal reportPiper Aerostar PA-60-602P · Kremmling, COThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall and spin.Sep 19, 2008 · N97TS · DestroyedNTSB DEN08FA155Accident · 2 fatalField investigationFinal reportCessna 172L · York, NEThe student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.Sep 19, 2008 · N4380Q · Substantial damageNTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…Sep 12, 2008 · N193BS · Substantial damageNTSB ANC08LA122Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain sufficient airspeed to preclude a stall while maneuvering at a low altitude, resulting in an uncontrolled descent and collision with terrain.Sep 11, 2008 · N7174K · Substantial damageNTSB NYC08CA309Accident · No injuriesData collectionFinal reportBell 206B · Eutaw, ALThe pilot's inadequate preflight inspection.Sep 9, 2008 · N206WA · Substantial damageNTSB DFW08TA225Accident · Serious injuriesFinal reportDiamond Aircraft Industries DA-20-C-1 · Pueblo, COThe student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.Sep 8, 2008 · N939DA · Substantial damageNTSB ANC08CA119Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's failure to attain/maintain sufficient flying speed during initial climb.Sep 8, 2008 · N9950Q · Substantial damageNTSB MIA08CA191Accident · No injuriesData collectionFinal reportAirframes Unlimited USA-1B · Surry, VAThe pilot's improper handling of the powered parachute during takeoff/initial climb.Sep 7, 2008 · N723JH · Substantial damageNTSB LAX08LA290Accident · 1 fatalLimited investigationFinal reportAirborne XT-912 · Chelan, WAThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.Sep 6, 2008 · N227EK · DestroyedNTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.Sep 3, 2008 · N597TB · Substantial damageNTSB SEA08GA194Accident · 3 fatalFinal reportLockheed P2V-7 · Reno, NVThe failure of the flight crew to maintain airspeed above in-flight minimum control speed (Vmca) after losing power in the left jet engine during initial climb after takeoff. Contributing to the accident was the crew's inadequate cockpit resource management…Sep 2, 2008 · N4235T · DestroyedNTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.Sep 1, 2008 · N251SP · Substantial damageNTSB ANC08CA117Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe student pilot's inadequate recovery from a bounced landing.Sep 1, 2008 · N2981M · Substantial damageNTSB SEA08LA192Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Camarillo, CAThe pilot's failure to fly the correct approach profile that resulted in the inadvertent pickup of a banner tow line with the airplane's main landing gear.Aug 31, 2008 · N7482D · Substantial damageNTSB MIA08FA177Accident · 1 fatalField investigationFinal reportCessna T310R · Latrobe, PAThe pilot's impairment/incapacitation (cardiovascular) resulting in the pilot being unable to control the airplane.Aug 31, 2008 · N3180M · Substantial damageNTSB MIA08CA176Accident · Serious injuriesData collectionFinal reportCameron ZL-60 · Anderson, SCThe pilot's improper use of the balloon burners.Aug 31, 2008 · N61ZL · Substantial damageNTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.Aug 31, 2008 · N30WK · Substantial damageNTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…Aug 31, 2008 · N37AE · DestroyedNTSB NYC08CA300Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Barceloneta, PRThe student pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the high winds.Aug 30, 2008 · N594TC · Substantial damageNTSB LAX08LA288Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Gerlach, NVThe pilot's failure to maintain aircraft control during an uncommanded pitch-up during the takeoff.Aug 30, 2008 · N287SR · Substantial damageNTSB SEA08LA190Accident · 1 fatalLimited investigationFinal reportLien Zodiac 601 XL · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control after the engine experienced a loss of power. Contributing to the accident was the mixture control arm separating from the fuel metering valve shaft.Aug 29, 2008 · N9881T · Substantial damageNTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.Aug 29, 2008 · N41411 · DestroyedNTSB DEN08CA148Accident · No injuriesData collectionFinal reportRobinson R-22 · Refugio, TXThe pilot failed to maintain adequate airspeed while maneuvering to land.Aug 29, 2008 · N2312 · Substantial damageNTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.Aug 27, 2008 · N189LA · Substantial damageNTSB NYC08LA289Accident · Minor injuriesLimited investigationFinal reportEuropro CZ Eurofox · Millbrook, NYThe pilot's failure to maintain directional control during takeoff.Aug 24, 2008 · N281P · Substantial damageNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB CHI08CA267Accident · No injuriesData collectionFinal reportHughes 269A · Bremen, OHThe pilot's failure to maintain sufficient main rotor speed during the quick-stop maneuver. Contributing to the accident was the drainage ditch.Aug 23, 2008 · N2256W · Substantial damageNTSB NYC08LA287Accident · Serious injuriesLimited investigationFinal reportBell 206A · Barnesville, PAThe pilot's failure to maintain control of the helicopter during the low-speed, low-altitude maneuver which resulted in a loss of tail rotor effectiveness.Aug 22, 2008 · N67AR · Substantial damageNTSB NYC08CA294Accident · No injuriesData collectionFinal reportSacrey W Michael Zenair CH · Fincastle, VAThe pilot's inadvertent premature rotation during takeoff.Aug 22, 2008 · N404BB · Substantial damageNTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.Aug 21, 2008 · N711BZ · DestroyedNTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.Aug 21, 2008 · N1106T · Substantial damageNTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.Aug 20, 2008 · N5316L · Substantial damageNTSB LAX08CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Lake Tahoe, CAThe pilot's inadequate compensation for the wind and density altitude conditions and failure to attain and maintain an adequate airspeed that resulted in a stall/mush.Aug 19, 2008 · N8053G · Substantial damageNTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.Aug 18, 2008 · N6702Q · Substantial damageNTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.Aug 16, 2008 · N494ES · Substantial damage