NTSB investigations
8,203 cases where the first occurrence was “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 c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250) 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 c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 NYC03FA153Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Montauk, NYA loss of control during climb for undetermined reasons.NTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.NTSB NYC03CA152Accident · Minor injuriesData collectionFinal reportMaule MX-7-235 · East Brady, PAThe pilot's failure to maintain control of the airplane during landing.NTSB DEN03LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Leadville, COthe pilot's inadequate compensation for wind conditions and his failure to attain adequate airspeed resulting in an inadvertent stall/mush. Contributing factors were the wind shear, runway light, fence post, and unsuitable terrain.NTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.NTSB CHI03LA203Accident · Serious injuriesLimited investigationFinal reportAerotrike DPS · Brandon, IAThe non-certificated pilot selected unsuitable terrain for takeoff when he departed from a bean field, and the airplane stalled as a result of low airspeed during takeoff climb. Factors to the accident included the pilot's total lack of experience, the…NTSB LAX03FA207Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Truckee, CAan in-flight loss of control due to the pilot's rotation to an excessive pitch up attitude after takeoff and his failure to maintain an adequate airspeed, which resulted in a stall. Factors in the accident were the high density altitude and the lack of stall…NTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.NTSB NYC03LA147Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · West Liberty, OHThe student pilots failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB LAX03CA220Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chandler, AZThe student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.NTSB FTW03LA200Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · San Antonio, TXThe pilot's failure to maintain minimum required airspeed while maneuvering, resulting in an inadvertent stall of the airplane.NTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.NTSB DEN03LA118Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Durango, COthe pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the high altitude on base turn and final approach, the low airspeed, the pilot's improper use of flaps, the inadvertent…NTSB LAX03CA215Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…NTSB DEN03LA115Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Bountiful, UTthe pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.NTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…NTSB DEN03FA111Accident · 1 fatalField investigationFinal reportHammond Vans RV-6A · La Junta, COthe pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.NTSB MIA03CA132Accident · Minor injuriesData collectionFinal reportParsons Trainer · New Smyrna, FLFailure of the pilot to maintain control of the gyrocopter.NTSB LAX03CA208Accident · No injuriesData collectionFinal reportCessna 172K · Overton, NVthe student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB SEA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Alzada, MTThe student pilot's failure to maintain adequate flying airspeed in a turn while maneuvering close to the ground resulting in a stall condition. A contributing factor was the turbulent wind conditions.NTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB SEA03CA112Accident · No injuriesData collectionFinal reportCessna 177 · Woodland, WAThe pilot's premature liftoff and his failure to maintain/obtain airspeed and directional control during takeoff.NTSB CHI03LA172Accident · Minor injuriesLimited investigationFinal reportBell 206B · Baxter, MNThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. Factors contributing to this accident were the helicopter's low airspeed, low altitude, the crosswind, and the trees.NTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.NTSB MIA03CA129Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kissimmee, FLThe inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…NTSB SEA03LA105Accident · No injuriesLimited investigationFinal reportCessna T337G · Lewistown, MTInadequate preflight planning/preparation prior to takeoff, and the pilot's failure to maintain aircraft control during the takeoff. An inadvertent stall and rough terrain were factors.NTSB DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.NTSB LAX03LA198Accident · No injuriesLimited investigationFinal reportKowtun Mini 500 · Phoenix, AZThe pilot's failure to maintain directional control of the helicopter.NTSB LAX03LA197Accident · 1 fatalLimited investigationFinal reportBell 47-G4 · Porterville, CAloss of control for undetermined reasons.NTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.NTSB DEN03TA102Accident · Minor injuriesFinal reportCessna 182R · Hobbs, NMThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB LAX03LA192Accident · 1 fatalLimited investigationFinal reportArgus CA-7 · Angleton, TXthe pilot's loss of lateral aircraft control. Also causal was the pilot's intentional flight with an asymmetrical fuel loading, and his improper use of the fuel system. A factor in the accident was the insufficient information provided by the kit manufacturer…NTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.NTSB ATL03FA104Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Battleboro, NCThe certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.NTSB LAX03LA185Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Ash Fork, AZThe pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall mush condition. Factors were the loose and uneven dirt runway surface, the known tailwind with gusts, and high density altitude.NTSB DEN03LA098Accident · Minor injuriesLimited investigationFinal reportHelio H800 · Cody, WYthe pilot's improper preflight planning and his failure to maintain aircraft control when returning to the airport. Factors contributing to the accident were the oil leak, the attempted precautionary landing, and the downdraft.NTSB CHI03FA150Accident · Serious injuriesField investigationFinal reportCessna 172M · West Chicago, ILThe abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.NTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.NTSB NYC03LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Montauk, NYThe pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.NTSB LAX03LA180Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502A · Raywood, TXthe pilot's encounter with a stall/mush condition in the takeoff initial climb due to his inadequate preflight/pretakeoff procedures and failure to set the wing flaps to the proper takeoff configuration before beginning the takeoff ground roll.NTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.NTSB MIA03LA116Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with trees.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB LAX03TA174Accident · Minor injuriesFinal reportCessna 182Q · So Lake Tahoe, CAa loss of pitch flight control authority due to the disconnection and separation of the elevator DOWN control cable turnbuckle. The separation of the turnbuckle was due to the severance of the safety wire by unknown persons at an unknown time.