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 ANC00FA093Accident · 1 fatalField investigationFinal reportCessna 180 · Thorne Bay, AKThe pilot-in-command's inadvertent stalling of the airplane.NTSB ANC00LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Anchorage, AKThe failure of the pilot-in-command (CFI) to adequately supervise the instructional flight. Factors in the accident were an inadvertent spin entry by the student, and the pilot-in-command's failure to utilize adequate altitude for a stall demonstration.NTSB LAX00LA276Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Cave Creek, AZThe pilot's inadequate in-flight planning/decision to attempt a hover in atmospheric conditions and over terrain that would require maximum helicopter performance, and which would leave no viable alternate actions in the event of difficulties.NTSB FTW00LA214Accident · 1 fatalLimited investigationFinal reportBurton/Boyton Celerity · Horseshoe Bend, ARThe loss of control while maneuvering for an undetermined reason.NTSB CHI00LA212Accident · 1 fatalLimited investigationFinal reportHess RH-1 Falcon · New Castle, INaircraft control not attained by the pilot.NTSB CHI00LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Warrensburg, MOinadequate airspeed on takeoff that resulted in a stall/mush condition. Factors associated with the accident were the wet, grass runway, and the trees near the departure end of the runway.NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.NTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.NTSB CHI00LA204Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Holstein, NEthe settling with power encountered by the pilot. A factor was the sudden windshift.NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.NTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.NTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.NTSB NYC00LA195Accident · No injuriesLimited investigationFinal reportFairchild M-62 · Grafton, OHThe pilot's failure to maintain control of the airplane while taking off.NTSB NYC00LA191Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Harpswell, METhe pilot-in-command's improper in-flight decision to maneuver at a low airspeed with a left-quartering tailwind which resulted in a loss of tailrotor effectiveness.NTSB FTW00FA201Accident · 1 fatalField investigationFinal reportCessna T210J · Athens, TXthe pilot's inadvertent stall during initial takeoff climb.NTSB MIA00LA210Accident · Minor injuriesLimited investigationFinal reportJames Browning Midget MUSTANG-I · Waycross, GAthe pilot's failure to maintain control during initial climb that resulted in the aircraft colliding with the ground and incurring damage. A factor in the accident was the pilot's diverted attention, when he inadvertently knocked the spectacles off his face…NTSB DEN00LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Montrose, COAn inadvertent stall/mush. Factors were high density altitude, weight and balance exceeded, and pilot fatigue.NTSB CHI00FA185Accident · 3 fatalField investigationFinal reportPiper PA-30 · Duluth, MNloss of control in flight for undetermined reason(s).NTSB CHI00LA181Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Champion, NEthe undetermined uncontrolled descent.NTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.NTSB MIA00LA202Accident · 1 fatalLimited investigationFinal reportCessna A188B · Inverness, MSThe failure of the pilot to maintain airspeed while reversing course during an aerial application flight resulting in the aircraft stalling, descending, impacting a tree, and crashing to the ground.NTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…NTSB NYC00FA183Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.NTSB NYC00LA184Accident · 2 fatalLimited investigationFinal reportHartzell Rans S-12 · Strattanville, PAThe pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.NTSB IAD00LA054Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · East North Port, NYThe pilot's failure to maintain adequate rotor RPM and failure to follow published recovery procedures after the low rotor RPM warning horn and caution light activated.NTSB CHI00LA179Accident · 1 fatalLimited investigationFinal reportNorton Volksplane VP-1 · Waconia, MNthe inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.NTSB MIA00LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Montgomery, ALthe student pilot's failure to maintain aircraft control upon encountering variable winds during the landing flare/touchdown and his failure to recover from the resulting bounced landing which resulted in substantial damage to the aircraft.NTSB FTW00LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Bovina, TXThe pilot's inadequate preflight planning, which resulted in the pilot exceeding the aircraft's takeoff performance. Factors were the high density altitude and the pilot's delayed load jettison.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.NTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.NTSB CHI00LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's failure to maintain control of the airplane which resulted in a stall/mush condition. Factors associated with the accident were the trees and gusty wind conditions which resulted in turbulence on takeoff.NTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.NTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.NTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.NTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.NTSB CHI00LA169Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, ILthe student pilot failed to properly flare the airplane while landing. A factor associated with the accident was the student pilot's lack of total experience.NTSB SEA00LA110Accident · 2 fatalLimited investigationFinal reportHoye Kolb Twinstar MK III · Bigfork, MTThe pilot's failure to maintain aircraft control. Inadequate altitude for recovery was a factor.NTSB FTW00LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ben Wheeler, TXThe pilot's inadvertent stall of the aircraft.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB LAX00LA234Accident · 1 fatalLimited investigationFinal reportBeech G35 · Byron, CAin-flight loss of control and inadvertent stall.NTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.NTSB LAX00FA230Accident · 2 fatalField investigationFinal reportMaule M4-210C · Willows, CAFailure of the pilot to maintain an adequate airspeed margin while maneuvering in steep turns at low altitude in gusty and strong tailwind conditions, which lead to a wind shear encounter and a stall/spin. A contributing factor in the accident was the pilot's…NTSB LAX00FA231Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · San Jose, CAThe pilot's failure to maintain control of the airplane for undetermined reasons while intentionally performing an aerobatic maneuver.NTSB SEA00LA104Accident · 2 fatalLimited investigationFinal reportLunn RV-6A · Hammett, IDThe pilot's entering an inadvertent stall condition, and the lack of adequate altitude in which to successfully recover before ground impact.NTSB LAX00LA226Accident · No injuriesLimited investigationFinal reportHughes 269C · Santa Clarita, CASettling with power precipitated by a wind direction change during the approach to land sequence and the check pilot's delayed remedial action to correct the event. Factors in the accident were crew resource management coordination concerning flight control…NTSB CHI00GA160Accident · 2 fatalFinal reportSchweizer 269C · Topeka, KSthe pilot's failure to maintain translational lift while maneuvering, and the loss of tail rotor effectiveness. Factors relating to this accident were the tailwind, low airspeed, low rotor rpm, and the pilot's lack of overall experience in helicopters.NTSB NYC00LA158Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Wauseon, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.