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 DCA24WA183Incident · Minor injuriesClass 5 · ForeignAirbus A320 · Dublin, IrelandNTSB DCA24WA137OccurrenceClass 5 · ForeignBoeing 727 · Malakal, South Sudan, SudanNTSB GAA24WA156Accident · No injuriesClass 5 · ForeignPiper 46 · Nova Iguaçu deGoiás, GO, BrazilNTSB ERA24LA153Accident · Minor injuriesClass 3 · LimitedFinal reportDenzil Velarde MTO Sport · Tavernier, FLThe gyroplane’s encounter with a tailwind during the initial climb, which resulted in a loss of airspeed and subsequent forced landing.NTSB DCA24WA145AccidentClass 5 · ForeignBoeing 787 · Tokyo, JapanNTSB ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.NTSB DCA24WA302OccurrenceClass 5 · ForeignBoeing 747 · London, United KingdomNTSB ENG24LA012IncidentClass 3 · LimitedFinal reportBritish Aerospace BAE 146 Series 200A · Missoula, MTThe use of a new long term fire retardant with a chemical composition incompatible with the retardant previously in use for the integration-operational field evaluation without adequate testing and qualification.NTSB DCA24WA119IncidentClass 5 · ForeignEmbraer ERJ190 · Lungga, Solomon IslandsNTSB DCA24WA067IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsNTSB DCA24WA031Incident · No injuriesClass 5 · ForeignBombardier CL600 2D24 · Okiyakpu, NigeriaNTSB CEN24LA031Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Manhattan, KSThe pilot’s improper modification of the engine cooling system that resulted in an engine overheat and total loss of power. Contributing to the accident was the pilot’s decision to continue the flight after the engine overheat light illuminated instead of…NTSB ERA24LA010Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Southport, NCThe student pilot’s use of carburetor heat during takeoff, which resulted in a partial loss of engine power during initial climb due to an excessively rich fuel-air mixture.NTSB GAA24WA057AccidentClass 5 · ForeignPiper PA-31-350 · Sioux Lookout, CanadaNTSB DCA23WA450IncidentClass 5 · ForeignBoeing 757 · Manchester, United KingdomNTSB ANC23LA064Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Skwentna, AKThe pilot’s decision to taxi the airplane through tall grass without visual reference to the surface which obscured uneven terrain.NTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomNTSB DCA23WA422Accident · No injuriesClass 5 · ForeignATR ATR72 · Gran Canaria, SpainNTSB DCA23WA413Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomNTSB DCA23WA414Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaNTSB GAA23WA184Accident · 2 fatalClass 4 · ForeignAmerican Champion 8KCAB · Charata, ArgentinaNTSB DCA23WA471IncidentClass 5 · ForeignBoeing 737 · Santa Clara, CubaNTSB DCA23WA351OccurrenceClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesNTSB ERA23LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEdmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GAThe pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.NTSB DCA23WA336OccurrenceClass 5 · ForeignEmbraer ERJ170 · Monterrey, MexicoNTSB DCA23WA470OccurrenceClass 5 · ForeignAirbus A320 · Vilnius, LithuaniaNTSB DCA23WA318IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandNTSB CEN23FA201Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Grand Isle, LAThe pilot’s operation of the airplane while intoxicated, resulting in its impact with the ocean.NTSB DCA23WA205Incident · No injuriesClass 5 · ForeignBoeing 737 · East Midlands, United KingdomNTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaNTSB GAA23WA083AccidentClass 5 · ForeignAirbus Helicopters EC175 · Aberdeen, United KingdomNTSB DCA23WA178IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.NTSB DCA23WA160Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Niederrhein/Weeze, GermanyNTSB WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…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 ENG23WA003IncidentClass 5 · ForeignBombardier BD-700-2A12 · Nanjing Lukou International Airport, Hong Kong SAR ChinaNTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshNTSB DCA23WA013IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeNTSB GAA22WA296AccidentClass 4 · ForeignCessna 208B · Timika, IndonesiaNTSB 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 GAA22WA315Incident · No injuriesClass 5 · ForeignCessna 560 · Salta, ArgentinaNTSB 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.