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 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 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 GAA25WA155Accident · 1 fatalClass 5 · ForeignCessna 182 · Allen, ArgentinaNTSB DCA25WA182IncidentClass 5 · ForeignBoeing 737 · Cairo, EgyptNTSB DCA25WA208Incident · No injuriesClass 5 · ForeignBoeing 737 · Muharraq Island, BahrainNTSB DCA25WA183OccurrenceClass 5 · ForeignBoeing 737 · Venizia, ItalyNTSB DCA25WA166Occurrence · No injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB 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 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 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…NTSB GAA25WA044Accident · 2 fatalClass 5 · ForeignBombardier BD100 · San Fernando, ArgentinaNTSB CEN25LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCapella FW1C50 · Ozark, MOThe pilot’s failure to maintain aircraft control during high-speed taxi.NTSB DCA25WA053IncidentClass 5 · ForeignBoeing 767 · Bogotá, ColombiaNTSB DCA25WA052Incident · No injuriesClass 5 · ForeignBoeing MD 10-30F · Santa Cruz, BoliviaNTSB CEN25LA049Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Camdenton, MOThe pilot’s poor flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR25LA047Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lewistown, MTThe pilot’s inadvertent impact with a rock during a landing on a grass strip.NTSB DCA25WA004OccurrenceClass 5 · ForeignBoeing 737 · Milan, ItalyNTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.NTSB GAA25WA020IncidentClass 5 · ForeignCessna U206F · Moora, AustraliaNTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.NTSB DCA24LA293Accident · No injuriesClass 4 · LimitedFinal reportBoeing 747-4HQF · Istanbul, TürkiyeThe fatigue failure of multiple hinge ribs associated with the right outboard aileron, which resulted in abnormal aileron movement and airframe vibration. Contributing to the failure was the mis-rigged condition of the right outboard aileron, which increased…NTSB GAA24WA247Accident · 5 fatalClass 5 · ForeignAirbus Helicopters AS350 · NepalNTSB DCA24WA246Incident · No injuriesClass 5 · ForeignBoeing 747 · Lod, IsraelNTSB 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 WPR24LA223Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic T210 · Arroyo Hondo, NMThe passenger’s failure to maintain a proper landing position and handhold during the landing sequence, which resulted in a serious injury.NTSB DCA24WA211OccurrenceClass 3 · ForeignBoeing 747-400F · Hong Kong, Hong Kong SAR ChinaNTSB CEN24LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Dalhart, TXThe pilot’s improper decision to take off with the airplane over its maximum allowable gross weight at a high density altitude, which degraded its climb performance and led an off airport landing.NTSB DCA26WA118Incident · No injuriesClass 5 · ForeignAirbus A320 · Dublin, IrelandNTSB GAA24WA181Incident · No injuriesClass 3 · ForeignCessna 550 · Basseterre, St. Kitts & NevisNTSB WPR24LA153Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Moriarty, NMThe pilot’s unstabilized approach, which resulted in a runway excursion and impact with terrain.NTSB GAA24WA167Accident · 8 fatalClass 5 · ForeignBeech 200 · Zapara Island, VenezuelaNTSB ERA24LA194Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hornell, NYA cabin fire as a result of a damaged lithium-ion battery pack.NTSB DCA24WA187Incident · No injuriesClass 5 · ForeignBoeing 737 · Edinburgh, United Kingdom