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 LAX08LA160Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger LSS · Moses Lake, WAThe pilot's inability to maintain control due to an in-flight separation of the vertical fin as a result of the failure of the airplane's builder to properly secure the vertical fin to the fuselage.May 31, 2008 · N95478 · Substantial damageNTSB LAX08CA159Accident · No injuriesData collectionFinal reportRobinson R22 · Salt Lake City, UTThe student's improper use of the anti torque pedals during a practice hover autorotation, which resulted in the helicopter rolling over. Additional causes of the accident were the certificated flight instructor's inadequate supervision of the maneuver and…May 31, 2008 · N268SH · Substantial damageNTSB SEA08LA145Accident · 2 fatalLimited investigationFinal reportPoulin L/Cullen D Lancair Legacy · Murrieta, CAThe pilot's inadequate preflight planning, which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed, which resulted in an inadvertent stall/spin and the subsequent collision with terrain.May 30, 2008 · N109DC · DestroyedNTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…May 30, 2008 · N9376W · Substantial damageNTSB SEA08CA144Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Reno, NVThe student pilot's failure to maintain translational lift airspeed while approaching the pinnacle and the certificated flight instructor's delayed remedial action and inadequate supervision of the flight.May 29, 2008 · N2024Z · Substantial damageNTSB SEA08LA142Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed while on approach to landing that resulted in a stall/mush. Contributing to the accident was the wind shear and the high density altitude condition.May 28, 2008 · N21134 · Substantial damageNTSB SEA08LA140Accident · Minor injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA loss of engine power due to the pilot's modification of the induction system, and the pilot's failure to maintain an adequate airspeed while maneuvering to a landing area following the power loss.May 26, 2008 · N4GJ · Substantial damageNTSB SEA08LA138Accident · 1 fatalLimited investigationFinal reportKolb Kolbra · Jordan Valley, ORThe pilot's failure to maintain an adequate airspeed while maneuvering that led to a stall/mush.May 25, 2008 · N49KK · Substantial damageNTSB SEA08CA141Accident · No injuriesData collectionFinal reportPiper PA-20 · Fields, ORThe pilot's failure to maintain aircraft control during the approach. Contributing to the accident was a windshear.May 25, 2008 · N7076K · Substantial damageNTSB NYC08CA194Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Valkaria, FLThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.May 25, 2008 · N1457E · Substantial damageNTSB DEN08CA093Accident · Minor injuriesData collectionFinal reportKitfox IV 1200 · FlyingBar Ranch, MOThe pilot's improper decision to takeoff with a quartering tailwind and failure to maintain aircraft control. Contributing to the accident were the gusting tailwind and operating the airplane near maximum gross weight.May 24, 2008 · N108KX · Substantial damageNTSB SEA08FA135Accident · 1 fatalField investigationFinal reportBeech 1900C · Billings, MTThe pilot's failure to maintain aircraft control during the initial climb for undetermined reasons.May 23, 2008 · N195GA · DestroyedNTSB MIA08LA105Accident · 1 fatalLimited investigationFinal reportAviate Raptor · Bealeton, VAAn in-flight loss of control for undetermined reasons.May 23, 2008 · N74TK · Substantial damageNTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.May 23, 2008 · N73471 · Substantial damageNTSB DFW08CA150Accident · Minor injuriesData collectionFinal reportCortesy, John E Airborne Edge-X · San Juan Pueblo, NMThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing to the accident was the loss of engine power for undetermined reasons.May 21, 2008 · N8072S · Substantial damageNTSB CHI08LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wrightsville, GAThe pilot's failure to maintain control during takeoff. Contributing to the accident were the gusty winds.May 18, 2008 · N4553J · Substantial damageNTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.May 17, 2008 · N4026T · Substantial damageNTSB MIA08CA100Accident · No injuriesData collectionFinal reportCessna 172A · Jamestown, PAThe pilot's failure to maintain control after takeoff resulting in contact with the ground. Contributing to the accident was the pilot's inadequate preflight planning resulting in a takeoff from a short, wet, soft, runway.May 13, 2008 · N9822T · Substantial damageNTSB NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.May 12, 2008 · N64FP · DestroyedNTSB CHI08FA133Accident · 2 fatalField investigationFinal reportBeech V35 · Bristol, OHThe loss of control during cruise flight in instrument conditions due to spatial disorientation.May 12, 2008 · N7947M · DestroyedNTSB NYC08CA179Accident · Minor injuriesData collectionFinal reportCessna T182T · Newport, RIThe pilot's failure to maintain adequate airspeed during a go-around. Contributing to the accident was the pilot's improper weather evaluation and a tailwind.May 10, 2008 · N65433 · Substantial damageNTSB DFW08LA140Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Marine · Austin, TXThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude, which resulted in a loss of control.May 10, 2008 · N8316D · Substantial damageNTSB CHI08CA136Accident · Serious injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's failure to adequately secure his handheld radio prior to takeoff, which resulted in a restriction of the flight control stick and loss of control. Contributing to the accident was the stall/mush flight condition encountered after the glider…May 10, 2008 · N24BS · Substantial damageNTSB LAX08FA134Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-GMBH EA-300/L · Queen Creek, AZThe loss of aircraft control due to an undetermined rudder malfunction.May 9, 2008 · N133EE · Substantial damageNTSB NYC08LA176Accident · 2 fatalLimited investigationFinal reportDesalvatore Al Lancair IV-P · Snow Hill, NCAn inadvertent encounter with icing conditions, resulting in a loss of aircraft control. Contributing to the accident was the pilot's inadequate preflight and in-flight decision making.May 8, 2008 · N101BX · DestroyedNTSB DFW08LA139Accident · No injuriesLimited investigationFinal reportCommander AC-680 · Hope, ARThe pilot's failure to maintain control of the twin-engine airplane while landing. Contributing to the accident were the crosswind and partial loss of power on the right engine.May 8, 2008 · N39BA · Substantial damageNTSB DFW08FA131Accident · 1 fatalField investigationFinal reportCessna 182 · Black Hawk, COThe loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.May 8, 2008 · N8553S · Substantial damageNTSB ANC08LA061Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Soldotna, AKThe pilot's failure to remove the rudder gust lock prior to the flight.May 6, 2008 · N9650S · Substantial damageNTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.May 5, 2008 · N5318F · Substantial damageNTSB SEA08CA122Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Nimbus-4M · Ephrata, WAThe pilot's inadequate preflight inspection and his failure to connect the left aileron control rod during assembly.May 4, 2008 · N747JN · Substantial damageNTSB SEA08CA123Accident · Minor injuriesData collectionFinal reportVans RV-7A · Hollister, CAThe in-flight collision with a bird.May 3, 2008 · N269SD · Substantial damageNTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.May 3, 2008 · N546B · Substantial damageNTSB SEA08LA120Accident · 2 fatalLimited investigationFinal reportYakovlev Yak 52 · Vancouver, WAThe pilot's failure to maintain an airspeed sufficient to avoid a stall during a low altitude aerobatic maneuver. Contributing to the accident was the low altitude at which the pilot initiated the maneuver.May 2, 2008 · N62813 · Substantial damageNTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.May 2, 2008 · N331MD · Substantial damageNTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…Apr 28, 2008 · N747CT · DestroyedNTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.Apr 27, 2008 · N429RM · DestroyedNTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.Apr 27, 2008 · N4513H · Substantial damageNTSB DFW08CA116Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Carlsbad, NMThe pilot's improper decision to takeoff uphill with full fuel and fuel chemical load. A factor was the pilot's failure to calculate performance data.Apr 25, 2008 · N402SK · Substantial damageNTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.Apr 23, 2008 · N25CL · DestroyedNTSB DFW08CA114Accident · No injuriesData collectionFinal reportHughes 269A · Killeen, TXThe pilot's failure to maintain main rotor RPM and a safe rate of descent during the autorotation. A contributing factor was the gusty winds.Apr 23, 2008 · N9064N · Substantial damageNTSB NYC08CA169Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Chapel Hill, NCThe pilot's improper recovery from a bounced landing. Contributing to the accident was the gusty wind conditions.Apr 22, 2008 · N345RP · Substantial damageNTSB DFW08CA124Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Rifle, COThe pilot's failure to maintain control of the airplane on landing. A factor was the crosswind and wind gusts.Apr 20, 2008 · N7417W · Substantial damageNTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.Apr 20, 2008 · N8517M · Substantial damageNTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.Apr 20, 2008 · N2049L · Substantial damageNTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.Apr 19, 2008 · N3921 · Substantial damageNTSB DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.Apr 19, 2008 · N94470 · Substantial damageNTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.Apr 19, 2008 · N532MA · Substantial damageNTSB DEN08FA078Accident · 2 fatalField investigationFinal reportCessna P206 · Mount Vernon, MOThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing factors in this accident were the entanglement of the parachute in the elevator control system, reducing the pilot's ability to regain control.Apr 19, 2008 · N2537X · DestroyedNTSB LAX08TA116Accident · No injuriesFinal reportHughes TH-55 · Logan, UTThe pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.Apr 18, 2008 · N6358Z · Substantial damageNTSB LAX08FA115Accident · 2 fatalField investigationFinal reportCessna 150J · Sonora, CAThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident were rising mountainous terrain and a high density altitude.Apr 18, 2008 · N60760 · Substantial damage