NTSB investigations
738 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 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 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 GAA22WA143Accident · No injuriesClass 5 · ForeignCessna 560XL · Sevilla, SpainNTSB GAA22WA156Accident · No injuriesClass 5 · ForeignBell 412 · Coelemu, ChileNTSB DCA22WA092IncidentClass 5 · ForeignBoeing 737 · Malaga, SpainNTSB CEN22LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Burleson, TXThe student pilot accidentally pulling the mixture control in the landing pattern which resulted in a loss of engine power and forced landing.NTSB ERA22LA115Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC-12/47E · Ronkonkoma, NYThe pilot’s failure to properly position the power control lever before starting the engine as required per the checklist. Contributing to the accident were the ice on the ramp and the pilot’s failure to secure the engine using the condition lever.NTSB CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.NTSB GAA22WA080Accident · No injuriesClass 5 · ForeignBell 412 · Valencia, SpainNTSB DCA22WA054IncidentClass 5 · ForeignBoeing 777 · Dubai, United Arab EmiratesNTSB DCA22WA063IncidentClass 5 · ForeignBoeing 737 · Singapore, SingaporeNTSB DCA22WA061Incident · No injuriesClass 5 · ForeignBoeing 737 · Cluj-Napoca, RomaniaNTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…NTSB GAA22WA003AccidentClass 3 · ForeignKaman K1200 · Whistler, CanadaNTSB GAA21WA245Accident · No injuriesClass 5 · ForeignHélicoptères Guimbal Cabri G2 · Ägerten, SwitzerlandNTSB GAA21WA214Accident · Minor injuriesClass 5 · ForeignAir Tractor AT802 · Popple Depot-New Brunswick, CanadaNTSB ERA21LA302Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot's failure to maintain an appropriate distance between the airplane and hangar, which resulted in substantial damage to the right wing.NTSB ERA21LA247Accident · Minor injuriesClass 3 · LimitedFinal reportGarrison Ronald L Zodiac 601 XL · Cumberland, MDAn inadvertent release of the canopy, which allowing the canopy to open during flight and led to an inflight loss of airplane control. Contributing to the accident was the lack of any safeguard to prevent the inadvertent opening of the canopy.NTSB WPR21LA202Accident · No injuriesClass 4 · LimitedFinal reportGoodsell Lynn A Classic 4 · Richmond, UTThe pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.NTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…NTSB GAA21WA124Accident · No injuriesClass 5 · ForeignRobinson R44 · Belo Horizonte, BrazilNTSB CEN21LA224Accident · Serious injuriesClass 3 · LimitedFinal reportDJI Matrice · Young Harris, GAThe remote pilot-in-command’s (RPIC) decision to physically hold onto the drone’s landing gear in flight, which resulted in the rotors striking his hand and causing serious injury. Contributing to the accident was the RPIC’s inadequate preflight planning and…NTSB ANC21LA023Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s selection of unsuitable terrain for taxi, which resulted in the airplane encountering a crevasse.NTSB CEN21LA132Accident · No injuriesClass 3 · LimitedFinal reportBeech B100 · Lubbock, TXThe failure of the right-side window inner pane for reasons that could not be determined based on available evidence.NTSB DCA21WA231Accident · No injuriesClass 5 · ForeignBoeing 737 · Ikeja, NigeriaNTSB WPR21LA109Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopter 369 · Mesa, AZThe pilot’s improper pitch attitude for landing and the inadequate supervision of the flight instructor, resulted in the main rotor blades impacting the tail boom.NTSB DCA21WA078Incident · No injuriesClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB ANC20CA097Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Arctic Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a rock damaging the empennage.NTSB DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanNTSB DCA20WA144Incident · No injuriesForeign investigationBoeing 737 · West Midland, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.NTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.NTSB CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.NTSB CEN20CA337Accident · Serious injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik L13 · Frankenmuth, MIThe pilot's failure to stow the speed brake prior to attempting takeoff.NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.NTSB ERA20LA288Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170 · Ardmore, TNThe pilot’s inadequate preflight planning and his decision to depart from a constrained, grass-covered field in elevated-density altitude conditions, which resulted in reduced takeoff and climb performance and a subsequent forced landing.NTSB CEN20CA334Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369 · Delia, KSForeign object damage sustained to the main rotor blades due to aerial tree trimming.NTSB CEN20CA320Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A188 · Memphis, MOThe pilot did not remove the rudder gust lock during the preflight inspection, which resulted in a forced landing and collision with a tree.NTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…NTSB ANC20CA068Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Ketchikan, AKThe crew leader's decision to throw a chainsaw bar into the moving arc of the main rotor blade.NTSB CEN20LA264Accident · No injuriesClass 3 · LimitedFinal reportMbb BK117 · Wooster, OHThe entanglement of construction fencing into the main rotor system, which necessitated a forced landing that resulted in substantial damage to the helicopter.NTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…NTSB ANC20CA063Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Nikolai, AKThe pilot's improper decision to depart from an unsuitable off-airport surface which resulted in a departure area excursion and impact with trees.NTSB ERA20LA219Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · McAlpin, FLThe pilot’s failure to abort the takeoff after recognizing poor airplane acceleration, the reason for which could not be determined based on available evidence. Contributing to the accident was the pilot’s likely inadvertent initiation of the takeoff with the…