NTSB investigations, 2009
307 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\") = 2009
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.
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") = 2009 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
Run 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 WPR09FA464Accident · No injuriesField investigationFinal reportEurocopter AS 350 B3 · Tucson, AZThe loss of directional control for undetermined reasons.NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB ANC09CA106Accident · Serious injuriesData collectionFinal reportRittal Alfred Timothy Glastar · Tuluksak, AKA loss of control for an undetermined reason during the takeoff portion of an aborted landing at an off-airport site, resulting in a collision with terrain.NTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…NTSB WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.NTSB WPR09LA451Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Hayward, CAThe pilot's failure to maintain directional control after takeoff. Contributing to the accident was the pilot's inadequate preflight and failure to follow the airplane manufacturer's checklist to ensure that the rudder trim control and right propeller control…NTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.NTSB ERA09FA515Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Rock Hill, SCThe pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.NTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB WPR09LA442Accident · Serious injuriesLimited investigationFinal reportSix Chuter SR 7 · Hooper, UTThe non-certificated pilot’s failure to maintain an adequate airspeed for the powered parachute while maneuvering at a low altitude.NTSB ERA09LA509Accident · Serious injuriesLimited investigationFinal reportHebert Kitfox Speedster · Morrisville, VTA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.NTSB ERA09LA501Accident · 2 fatalLimited investigationFinal reportKeithley Thomas E Starduster Too · St. Matthews, SCA loss of airplane control during approach for undetermined reasons.NTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.NTSB CEN09CA564Accident · No injuriesData collectionFinal reportCessna 180G · Canby, MNThe pilot's failure to maintain directional control of the airplane while landing in gusting crosswinds.NTSB ANC09LA098Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Central, AKThe pilot’s failure to maintain control of the helicopter after an in-flight encounter with a downdraft while landing. Contributing to the accident was the pilot’s inadequate evaluation of wind conditions.NTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09LA565Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Arvilla, NDThe aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.NTSB CEN09CA566Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mondovi, WIThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an aerodynamic stall.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB CEN09LA561Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Stacy, MNA partial loss of engine power during initial climb for undetermined reasons.NTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB CEN09CA615Accident · No injuriesData collectionFinal reportCessna 175 · Rio Blanco, COThe pilot's failure to maintain directional control during landing and his failure to execute a go-around.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.NTSB ERA09LA483Accident · 2 fatalLimited investigationFinal reportBeech C24R · Sylva, NCThe pilot's failure to maintain an adequate airspeed during an aborted landing, which resulted in an aerodynamic stall.NTSB ERA09CA485Accident · No injuriesData collectionFinal reportBell 206L-3 · White Plains, NYThe pilot's failure to disconnect the ground power unit prior to takeoff.NTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.NTSB ERA09CA484Accident · No injuriesData collectionFinal reportPiper PA-34 · Savannah, GAThe student pilot's failure to maintain pitch control during landing and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…NTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB CEN09LA536Accident · 2 fatalLimited investigationFinal reportBrown Steen Skybolt · Harrison, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB WPR09LA411Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Tonopah, NVThe pilot’s failure to maneuver the helicopter within its performance capabilities while at a low altitude in mountainous terrain and in high density altitude conditions.NTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.NTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB CEN09CA533Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Whittemore, IAThe pilot's lack of preflight planning and remedial action with resulted in the airplane's inability to climb out of ground effect.NTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…NTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.NTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.NTSB CEN09LA527Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Corning, IAThe in-flight loss of control due to the pilot's impairment as a result of hypoxia. Contributing to the accident was the pilot's decision to operate the unpressurized airplane at an altitude requiring supplemental oxygen without having any oxygen available.NTSB CEN09WA524Accident · 2 fatalForeign investigationBeech 99 · Évora, PortugalUnder the jurisdiction and control of the Portuguese government.NTSB CEN09FA518Accident · 2 fatalField investigationFinal reportBeech E18S · Eden Prairie, MNThe pilot’s lack of experience flying the accident make and model of airplane, which led to a loss of control while maneuvering to return to the airport. Contributing to the accident was a partial loss of engine power for undetermined reasons.