NTSB investigations
1,558 cases where the sequence of events included Miscellaneous/other.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' 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 c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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 DCA23WA161Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Bremen, GermanyNTSB DCA23WA087Incident · No injuriesClass 5 · ForeignAirbus A319-115 · Barranquilla, ColombiaNTSB DCA23WA069IncidentClass 5 · ForeignBeech 1900 · Fortnam, AustraliaNTSB DCA23WA049Incident · Minor injuriesClass 5 · ForeignSaab 340 · Canberra, AustraliaNTSB DCA23WA048IncidentClass 5 · ForeignBoeing 737 · Winnipeg, CanadaNTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.NTSB ENG23WA003IncidentClass 5 · ForeignBombardier BD-700-2A12 · Nanjing Lukou International Airport, Hong Kong SAR ChinaNTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshNTSB WPR23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Evanston, WYThe pilot’s failure to maintain directional control during takeoff, resulting in a runway excursion and ground loopNTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB DCA23WA013IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeNTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…NTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…NTSB GAA22WA293AccidentClass 5 · ForeignFairchild 227 · Queretaro, MexicoNTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB GAA22WA296AccidentClass 4 · ForeignCessna 208B · Timika, IndonesiaNTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.NTSB CEN22LA393Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Harvard, ILThe pilot’s failure to maintain directional control during take-off, which resulted in a collision with crop and terrain.NTSB ERA22LA375Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The pilot's suicide.NTSB GAA22WA251Incident · No injuriesClass 5 · ForeignChristen Industries A1 · Menuma, JapanNTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.NTSB WPR22LA290Accident · No injuriesClass 3 · LimitedFinal reportEADS Socata TBM 700 · Carlsbad, NMThe pilot’s failure to extend the landing gear before landing due to a distraction, which resulted in an impact with the runway.NTSB ERA22LA348Accident · 1 fatalClass 3 · LimitedFinal reportCASA C212 · Raeford, NCThe airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.NTSB GAA22WA315Incident · No injuriesClass 5 · ForeignCessna 560 · Salta, ArgentinaNTSB WPR22FA264Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-235 · Seguin, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…NTSB CEN22LA302Accident · Minor injuriesClass 4 · LimitedFinal reportPitts S1 · Sturgeon Bay, WIThe pilot’s failure to maintain airplane control during landing, which resulted in a runway excursion and nose over. Contributing to the accident was the pilot’s inadequate preflight inspection and the pilot’s lack of flight control system knowledge.NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB ERA22LA277Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hunter · Wilmington, NCA bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.NTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.NTSB ERA22LA269Accident · No injuriesClass 4 · LimitedFinal reportWalter S Johnson III AR-1 · Butler, PAThe pilot’s failure to monitor rotor disk speed on takeoff, which resulted in blade flapping and the main rotor blades striking the gyroplane’s tail assembly.NTSB CEN22LA238Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Hot Springs, SDThe passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.NTSB WPR22LA205Accident · No injuriesClass 4 · LimitedFinal reportBell HH-1H · Reno, NVThe pilot’s loss of control following the inadvertent placement of his foot behind the anti-torque pedal.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 WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.NTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.NTSB ERA22LA213Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV7 · Huntsville, ALThe pilot’s impairment due to the effects of ethanol, which resulted in a loss of airplane control and an impact with terrain on approach to landing.NTSB ERA22LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Honesdale, PAThe pilot’s failure to maintain clearance with the edge of the asphalt, which resulted in a runway excursion. Contributing to the accident was the pilot’s distraction due to a goose.NTSB GAA22WA153Accident · 1 fatalClass 5 · ForeignAgusta AW139 · Iwaizumi, JapanNTSB DCA22WA108IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB CEN22LA177Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · McAllen, TXThe pilot’s failure to extend the landing gear due to distraction.NTSB GAA22WA143Accident · No injuriesClass 5 · ForeignCessna 560XL · Sevilla, SpainNTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA22WA156Accident · No injuriesClass 5 · ForeignBell 412 · Coelemu, ChileNTSB DCA22WA092IncidentClass 5 · ForeignBoeing 737 · Malaga, SpainNTSB WPR22LA116Accident · No injuriesClass 4 · LimitedFinal reportLiberty Aerospace Liberty XL-2 · Las Cruces, NMThe airplane’s inability to climb during takeoff due to a degradation of engine performance due to high density altitude. Contributing to the accident was the pilot’s decision to continue the takeoff.NTSB ERA22LA143Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Manassas, VAThe student pilot’s improper left rudder input after power application during the touch-and-go landing which resulted in a runway excursion and collision with airport lighting equipment. Contributing to the accident was the flight instructor’s inadequate…NTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.