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 CEN25LA390Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US Z-90 · Cedar Springs, MIThe passenger’s loss of balance during landing that resulted in a serious injury.NTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB ERA25LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Fly Balonismo E Inflaveis AF-SS-94 · Walbridge, OHThe balloon pilot’s failure to see and avoid powerlines during an off-field airport landing.NTSB ANC25LA097Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3e · Skwentna, AKThe pilot’s inadvertent entanglement of a lightweight Kevlar long line into the helicopters operating main rotor system, resulting in a severe imbalance and separation of the main rotor gearbox.NTSB ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB ANC25LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Haines, AKThe pilot’s selection of an unsuitable landing area resulting in an on-ground collision with an obscured log and a main landing gear separation.NTSB GAA25WA242Accident · No injuriesClass 5 · ForeignMD Helicopters 600N · Storrington, United KingdomNTSB DCA25WA300IncidentClass 5 · ForeignAirbus A320 · Caloundra, AustraliaNTSB CEN25FA307Accident · 2 fatalClass 3 · FieldFinal reportHughes 369D · West Alton, MOThe pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.NTSB DCA25WA279Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Cairns, AustraliaNTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.NTSB DCA25WA245IncidentClass 5 · ForeignBoeing 737 · Mascot, AustriaNTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.NTSB DCA25WA254Incident · No injuriesClass 5 · ForeignDouglas DC9 · El Vigía, VenezuelaNTSB GAA25WA215Incident · No injuriesClass 5 · ForeignCessna 650 · Mallorca, SpainNTSB DCA25WA257IncidentClass 5 · ForeignBoeing 737 · Melbourne Airport, AustraliaNTSB DCA25WA334IncidentClass 5 · ForeignBoeing 737-8 · Stansted, United KingdomNTSB WPR25LA192Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASH 30 MI · Santa Barbara, CAThe pilot’s failure to maintain taxiway centerline while taxiing off the runway which resulted in a left-wing strike with a runway direction sign.NTSB DCA25WA256IncidentClass 5 · ForeignAirbus A321 · Sydney, AustraliaNTSB GAA25WA201AccidentClass 5 · ForeignAugusta AW119 · Bhubaneswar, IndiaNTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.NTSB GAA25WA185AccidentClass 5 · ForeignBell 407 · Guptkashi, IndiaNTSB GAA25WA187AccidentClass 5 · ForeignPiper PA28 · Ladysmith, South AfricaNTSB CEN25LA196Accident · Minor injuriesClass 4 · LimitedFinal reportGallow Daniel A Kitfox Classic IV · Waupaca, WIThe pilot’s failure to maintain adequate air speed during final approach, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA25WA180AccidentClass 5 · ForeignCessna 500 · Naiguata, VenezuelaNTSB GAA25WA175AccidentClass 5 · ForeignGulfstream Aerospace G-IV · Robertsfield, LiberiaNTSB GAA25WA174Incident · No injuriesClass 5 · ForeignPiper PA34 · Karachi, PakistanNTSB DCA25WA216IncidentClass 5 · ForeignEmbraer ERJ190 · Nueva Linda, MexicoNTSB DCA25WA217IncidentClass 5 · ForeignBoeing 777 · Schiphol, NetherlandsNTSB DCA25WA211Accident · No injuriesClass 5 · ForeignBoeing 737 · Kos, GreeceNTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB ERA25LA197Accident · No injuriesClass 4 · LimitedFinal reportArlie L Raber III Challenger 1 · Crestview, FLThe pilot’s decision to take off despite having problems controlling the airplane due to his physical stature.NTSB GAA25WA155Accident · 1 fatalClass 5 · ForeignCessna 182 · Allen, ArgentinaNTSB ERA25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportHiller UH12E · Rockledge, FLOn April 6, 2025, about 1020 eastern daylight time, a Hiller UH-12E, N48263, was substantially damaged when it was involved in an accident near Rockledge, Florida. The private pilot and passenger sustained serious injuries. The helicopter was operated as a…NTSB DCA25WA182IncidentClass 5 · ForeignBoeing 737 · Cairo, EgyptNTSB DCA25WA208Incident · No injuriesClass 5 · ForeignBoeing 737 · Muharraq Island, BahrainNTSB ERA25LA155Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SF50 · Kissimmee, FLOn March 24, 2025 about 0804 eastern daylight time, a Cirrus Design Corporation SF50, N56GY, was substantially damaged when it was involved in an accident at Kissimmee Gateway Airport (ISM), Orlando, Florida. The commercial pilot was not injured. The airplane…NTSB DCA25WA183OccurrenceClass 5 · ForeignBoeing 737 · Venizia, ItalyNTSB DCA25WA166Occurrence · No injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB WPR25LA112Accident · Serious injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Waterford, CAThe pilot’s failure to maintain clearance from water while operating at a low altitude.NTSB ENG25WA028IncidentClass 5 · ForeignAirbus A320 · Tijuana, MexicoNTSB WPR25LA110Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Las Vegas, NVThe pilot’s loss of helicopter control after the door opened during takeoff. Contributing to the accident was the pilot’s failure to confirm that the door was properly closed before departure.NTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB DCA25WA165OccurrenceClass 5 · ForeignEmbraer 190 · The Granites, AustraliaNTSB DCA25WA157Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Eaton, AustraliaNTSB DCA25WA153IncidentClass 5 · ForeignEmbraer 190LR · Olympic Dam, AustraliaNTSB DCA25WA122Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ190 · Olympic Dam, AustraliaNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorNTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.NTSB DCA25LA065Accident · Serious injuriesClass 3 · LimitedFinal reportUvify IFO · Orlando, FLThe remote pilot-in-command’s (RPIC’s) failure to locate the drone show center position over the physical location of the sUA, which resulted in multiple sUA colliding during the initial lift and subsequent loss of control. Contributing to the accident was…