NTSB investigations
12,339 cases where NTSB found Aircraft oper/perf/capability.
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\", '0106')) 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", '0106')) 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 CEN24LA257Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Sedgwick, ARThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB WPR24FA227Accident · 1 fatalClass 3 · FieldFinal reportFantasy Air Sro Allegro 2007 · Eureka, UTThe pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.NTSB WPR24FA226Accident · 2 fatalClass 3 · FieldFinal reportChampion 7GCBC · Eatonville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.NTSB ERA24LA296Accident · Serious injuriesClass 4 · LimitedFinal reportMissoula Super Drifter · Lafayette, TNThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.NTSB WPR24LA237Accident · No injuriesClass 4 · LimitedFinal reportBaxter Daniel David Starduster TOO SA300 · Scappoose, ORThe pilot’s failure to maintain directional control during landing roll with a tailwheel shimmy.NTSB WPR24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sunriver, ORThe pilot’s loss of control during landing roll with a gusty tailwind.NTSB CEN24LA254Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV8 · Atwater, MNThe pilot’s inability to stop the landing roll on a wet grass runway which resulted in a runway overrun.NTSB CEN24FA248Accident · 1 fatalClass 3 · FieldFinal reportRotorway Scorpion 133 · Andale, KSThe pilot’s abrupt control inputs, which resulted in a low-G condition, main rotor mast bumping, and subsequent severing of the tailboom by the main rotor blades.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB ERA24LA299Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 8GCBC · Frankford, DEA partial loss of engine power resulting from cylinder detonation and a cracked spark plug, which resulted in a forced landing and impact with terrain.NTSB ERA24FA292Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · Lock Haven, PAThe student pilot’s premature turn to the crosswind leg of the traffic pattern at low airspeed and altitude, resulting in a collision with trees and terrain.NTSB CEN24LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Florence, MOThe pilot’s failure to maintain proper altitude/clearance from a dead tree limb during an aerial application flight.NTSB CEN24LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Dowagiac, MIThe pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.NTSB WPR24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV-12IS · Scappoose, ORThe pilot’s failure to remove the seat belt used as a flight control lock from the right control stick before takeoff, which resulted in a loss of control, an aerodynamic stall, and a collision with terrain during takeoff. Contributing to the accident was the…NTSB ANC24LA060Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Susitna, AKThe pilot’s selection of an unsuitable takeoff area, resulting in the floats contacting the shallow river bottom during takeoff, and a subsequent loss of control.NTSB WPR24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tacoma, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.NTSB ERA24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Richmond, VAThe pilot’s failure to maintain directional control of the airplane while landing in rain and gusting wind conditions.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB ERA24LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCorella Neil RV9A · Saluda, SCThe pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.NTSB WPR24LA220Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Cedar City, UTThe pilot’s failure to maintain directional control during the landing roll, with gusty tailwind.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB CEN24LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Duluth, MNThe failure of the left engine induction coupling during takeoff, which resulted in a total loss of left engine power and an uncommanded left yaw/roll due to asymmetrical thrust and increased drag, from which the pilot had insufficient altitude to recover…NTSB CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.NTSB CEN24FA240Accident · 2 fatalClass 3 · FieldFinal reportCessna 414A · McKinney, TXThe pilot's improper decision to attempt continued flight after a loss of left engine power with usable runway remaining and his subsequent failure to follow the emergency procedures and maintain air minimum control speed, which resulted in a loss of control.…NTSB ANC24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Cordova, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ANC24LA055Accident · No injuriesClass 4 · LimitedFinal reportGippsland GA-8 · Tuntutuliak, AKThe pilot's failure to maintain directional control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.NTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.NTSB WPR24LA214Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CAThe pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.NTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB ERA24LA276Accident · Minor injuriesClass 3 · LimitedFinal reportSnyder Searey · New Ipswich, NHA total loss of engine power due to the exhaust muffler and tailpipe assembly separating from its attach points and impacting the propeller.NTSB ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ANC24LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tok, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB CEN24LA349Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Hooper, NEThe solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landingNTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.NTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.NTSB CEN24LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Schriever, LAThe pilot’s inadvertent application of the toe brakes during the takeoff roll.NTSB WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.NTSB WPR24FA202Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Capitan, NMThe pilot’s decision to continue the visual flight rules flight through an apparent visual corridor that rapidly narrowed due to rising terrain and mountain obscuration, resulting in momentary instrument meteorological conditions and the pilot’s subsequent…NTSB ERA24LA272Accident · No injuriesClass 4 · LimitedFinal reportAdams Walter R Searey · Sopchoppy, FLThe pilot’s improper landing flare, which resulted in abnormal contact with the water during landing.NTSB ANC24LA054Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Aleknagik, AKThe pilot’s failure to maintain pitch control of the airplane during initial climb.NTSB CEN24LA318Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Stanwood, MIThe pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…NTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.NTSB WPR24FA200Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bluestem, WAThe pilot’s failure to manage main rotor rpm during an autorotation, which resulted in a loss of helicopter control. Contributing to the accident was a loss of power for reasons that could not be determined.NTSB CEN24LA232Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Ruston, LAThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.