NTSB investigations
1,269 cases where NTSB found Performance/control parameters, general.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062000')) 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 CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB CEN23FA201Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Grand Isle, LAThe pilot’s operation of the airplane while intoxicated, resulting in its impact with the ocean.NTSB CEN23FA190Accident · 1 fatalClass 3 · FieldFinal reportBeech E-90 · Winslow, ARThe pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB ERA23FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 177B · Watkinsville, GAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an in-flight overload separation of the right wing during the uncontrolled descent.NTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA23FA181Accident · 4 fatalClass 3 · FieldFinal reportPiper PA32R · Venice, FLThe pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.NTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.NTSB ERA23FA175Accident · 2 fatalClass 3 · FieldFinal reportAirbus Helicopters EC 130 T2 · Chelsea, ALThe pilot’s delayed corrective inputs while maneuvering, which resulted in a loss of control. Contributing to the accident was the pilot’s use of multiple sedating medications.NTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.NTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB CEN23FA095Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Hooker, OKThe pilot’s decision to depart and continue the visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.NTSB CEN23FA079Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-301T · Kingfisher, OKAn oil leak of undetermined origin that resulted in an in-flight engine compartment fire and subsequent loss of airplane control.NTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.NTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.NTSB ERA23LA076Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics X1 · Trinity, NCThe pilot's failure to maintain control of the airplane during initial climb in gusting wind conditions, which resulted in a collision with power lines and trees.NTSB CEN23LA052Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Del Rio, TXThe pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.NTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.NTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.NTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.NTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB WPR23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Georgetown, CAThe pilot’s failure to maintain control during an attempted go-around, which resulted in a runway excursion and a separation of the right main landing gear.NTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.NTSB CEN22LA427Accident · No injuriesClass 3 · LimitedFinal reportCessna A188A · Canby, MNThe pilot’s failure to maintain airplane control during the landing, which resulted in an overload failure of the tailwheel cross tube and subsequent impact with the runway.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB ANC22FA069Accident · 1 fatalClass 3 · FieldFinal reportStory Charles Brad TT FOX · Wasilla, AKThe pilot’s inability to maintain control of the airplane for reasons that could not be determined.NTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.NTSB ERA22FA368Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Metz, WVThe non-instrument-rated pilot’s intentional visual flight into instrument meteorological conditions based on latent weather information, which resulted in the airplane entering extreme precipitation, a loss of aircraft control, and in-flight break-up.NTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.NTSB CEN22LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna T310R · Oshkosh, WIThe pilot’s loss of control while landing.NTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.NTSB WPR22LA253Accident · 2 fatalClass 3 · LimitedFinal reportCessna P210N · Buffalo, WYThe pilot’s decision to continue the visual flight rules flight into localized instrument meteorological conditions, which resulted in an encounter with convective turbulence and a subsequent loss of control and in-flight breakup.NTSB WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.NTSB CEN22LA279Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Yoder, KSThe pilot's encounter with sinking air conditions that resulted in a loss of lift and a subsequent loss of control.NTSB CEN22LA241Accident · Serious injuriesClass 4 · LimitedFinal reportAmerican AA-1A · Granite Falls, MNThe pilot’s failure to maintain airplane control while in the airport traffic pattern that resulted in an uncontrolled descent and impact with terrain.NTSB CEN22LA219Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cameron, TXThe flight crew not maintaining lateral control of the helicopter during hovering operation which resulted in a dynamic rollover.NTSB CEN22LA212Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Madison, MNThe pilot’s failure to maintain aircraft control during landing that resulted in an impact with terrain.NTSB WPR22FA184Accident · 1 fatalClass 3 · FieldFinal reportBruce R Prouse M24 Orion Plus · Cape Girardeau, MOThe pilot’s failure to maintain controlled flight, which resulted in a hard left roll, excessive blade flapping and a subsequent in-flight separation of the right horizontal stabilizer.NTSB WPR22LA182Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS 350B3 · Christmas Valley, ORThe pilot’s inability to maintain control in high wind conditions while repositioning during a landing attempt, which resulted in a loss of control and collision with terrain.NTSB CEN22FA203Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe student pilot’s decision to operate the airplane after consuming alcohol, which led to an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and a subsequent loss of control at a low altitude.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB ERA22LA229Accident · No injuriesClass 3 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Rochester, NYAn unintentional movement of the cyclic control before takeoff, which resulted the main rotor blades contacting the fixed wire cutter.NTSB ANC22FA030Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Gila Bend, AZThe student pilot’s failure to maintain control during the landing approach.NTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.NTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.NTSB CEN22LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Lampasas, TXThe pilot’s decision to perform a takeoff from a perpendicular taxiway rather than the airport runway, which led to the airplane striking trees at the end of the departure path.NTSB CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.NTSB CEN22FA151Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Rowlett, TXA loss of helicopter control while maneuvering, which resulted in main rotor blade contact with the tailboom in flight, tail boom separation, and an uncontrolled descent.