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.
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
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 MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB NYC08FA239Accident · 1 fatalField investigationFinal reportJahns Vans RV-7 · Neptune, NJAn in-flight loss of control for undetermined reasons.NTSB NYC08CA241Accident · Minor injuriesData collectionFinal reportStol UC-1 Twin Bee · Bunnell, FLThe flight instructor's inadequate recovery from a bounced landing.NTSB DEN08LA118Accident · No injuriesLimited investigationFinal reportMooney M20M · Elbert, COThe pilot's failure to maintain aircraft control during a go-around, resulting in an aerodynamic stall. Contributing to the accident was the high density altitude.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB DFW08CA188Accident · No injuriesData collectionFinal reportBell 47G-3B · Mullen, NEThe plot's distraction with the chemical load resulting the failure to maintain control of the helicopter. A factor was no suitable terrain for landing.NTSB CHI08CA174Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Greenwood, ILThe student pilot's inadequate compensation for the gusting crosswind, and the flight instructor's delayed remedial actions that resulted in a loss of control during the go-around maneuver. Contributing to the accident was the gusting wind condition.NTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…NTSB ANC08FA079Accident · 1 fatalField investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…NTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.NTSB LAX08CA205Accident · Serious injuriesData collectionFinal reportLa Moutte Trike · Weizer, IDThe pilot's failure to maintain adequate airspeed, which resulted in a stall.NTSB DFW08FA170Accident · 5 fatalField investigationFinal reportCessna U206F · Santa Rosa, NMThe pilot's failure to maintain safe flying airspeed for undetermined reasons resulting in an inadvertent stall.NTSB DFW08CA171Accident · Minor injuriesData collectionFinal reportMooney M20 · Lake Ft Gibson, OKThe pilot's loss of control while maneuvering the aircraft.NTSB MIA08CA127Accident · Minor injuriesData collectionFinal reportLima Sky Raider I · Homestead, FLThe pilot's failure to maintain airspeed during initial climb.NTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.NTSB NYC08LA228Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toms River, NJThe failure of the pilot's seat to engage or remain engaged due to the improper inspection of the worn seat tracks.NTSB LAX08CA189Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot's failure to attain and maintain an adequate airspeed during a go around, that resulted in a stall/mush. Contributing to the accident was the tailwind condition.NTSB DFW08LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Bethany, MOThe pilot's decision to take off with a known deficiency.NTSB DEN08FA114Accident · 2 fatalField investigationFinal reportAero Commander 500S · Linwood, KSThe pilot-in-training inadvertently shutting off both engine fuel control valves causing a loss of power in both engines, and the pilot's failure to maintain control of the airplane resulting in a stall. Contributing to the accident was the chief pilot's…NTSB DFW08CA168Accident · Minor injuriesData collectionFinal reportGrumman G-164 · Tallulah, LAThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's failure to maintain adequate airspeed.NTSB CHI08CA168Accident · No injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INThe pilot/builder's failure to manufacture the airplane with an appropriate engine thrust angle. Contributing to the accident was the pilot/builder's adjustment of the horizontal stabilizer which rendered the airplane uncontrollable.NTSB DEN08LA111Accident · No injuriesLimited investigationFinal reportCessna 172R · Tishomingo, OKThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall during the landing flare. Contributing factors in this accident was the terrain-induced turbulence, and the instructor's inadequate supervision of the pilot.NTSB NYC08LA221Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Lake Placid, FLThe pilot’s performance of a nonstandard abrupt maneuver at low altitude, which resulted in a loss of aircraft control.NTSB MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.NTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.NTSB NYC08FA218Accident · 1 fatalField investigationFinal reportDehavilland DHC6 · Hyannis, MAThe pilot's failure to remove the flight control lock prior to takeoff. Contributing to the accident was the Federal Aviation Administration's failure to issue an airworthiness directive making the manufacturer's previously-issued flight control lock service…NTSB LAX08CA185Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Philomath, ORThe student pilot's failure to maintain rotor rpm during a pinnacle approach and the flight instructor's delayed remedial action and inadequate supervision of the flight. Contributing to the accident was the downdraft weather condition.NTSB DFW08CA179Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Wharton, TXThe pilot's failure to maintain aircraft control.NTSB MIA08LA121Accident · 1 fatalLimited investigationFinal reportMckeehan James F Acroduster II SA750 · Panama City, FLThe pilot's inability to recover from an intentional aerobatic maneuver due to loss of aileron control. Contributing to the accident was the installation of an inadequate aileron secondary stop block against the main spar of both lower wings.NTSB NYC08FA215Accident · 2 fatalField investigationFinal reportCessna P337H · Cape Elizabeth, METhe pilot's improper decision to continue the flight in instrument meteorological conditions after experiencing an attitude indicator malfunction.NTSB DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.NTSB CHI08CA164Accident · Minor injuriesData collectionFinal reportHughes 269B · Cook, MNThe pilot not maintaining tail rotor effectiveness while turning in cruise.NTSB LAX08LA181Accident · 1 fatalLimited investigationFinal reportAirborne Edge · Dunn, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB NYC08LA213Accident · Minor injuriesLimited investigationFinal reportMarrin Pitts S-1 · St. Petersburg, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall. Contributing to the accident was improper maintenance practices during the construction of the airplane, which resulted in…NTSB LAX08LA179Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Beaver, UTThe pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.NTSB MIA08CA117Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fayetteville, GAThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot's relinquish of control to a non-certificated pilot.NTSB DEN08LA102Accident · No injuriesLimited investigationFinal reportCessna 150G · Brenham, TXThe sudden windshift (crosswind gust), rendering directional control impossible. Contributing factors in this accident were the high speed during the aborted takeoff and trees.NTSB NYC08FA211Accident · Serious injuriesField investigationFinal reportAvid Mark IV Aerobat · Niceville, FLThe pilot's loss of control during landing for undetermined reasons.NTSB CHI08FA156Accident · 6 fatalField investigationFinal reportCessna U206C · Fremont, OHThe pilot’s failure to maintain airplane control for an undetermined reason, which resulted in an inadvertent stall. Contributing to the accident was the pilot's poor judgment in continuing to fly with his severe visual deficiency. Also contributing to the…NTSB DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.NTSB ANC08FA072Accident · 1 fatalField investigationFinal reportPiper PA-18 · Quinhagak, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude in high winds, resulting in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident were the high winds.NTSB CHI08LA153Accident · No injuriesLimited investigationFinal reportJust Highlander · Danville, PAThe student pilot's loss of control during takeoff.NTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…NTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.NTSB CHI08FA150Accident · 1 fatalField investigationFinal reportSocata TBM 700 (850) · Iowa City, IAThe pilot's improper decision to depart with a preexisting tailwind and failure to abort takeoff. Contributing to the severity of the injuries was the failure to properly restrain (FAA-required) the child passenger.NTSB DEN08LA098Accident · 2 fatalLimited investigationFinal reportHarms Robert M KIT FOX SE · La Porte, TXThe pilot's failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and uncontrolled descent.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB DFW08LA157Accident · 1 fatalLimited investigationFinal reportLucas D E/ Lucas K A AcroSport II · St Charles, MOThe pilot's failure to maintain control during an attempted low pass maneuver.