Skip to content

NTSB investigations, 2023

28 cases where the defining event was Miscellaneous/other.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2023 AND 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

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 year(c.\"eventDate\") = 2023
    AND 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 year(c."eventDate") = 2023
  AND 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 DCA24WA067IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsDec 19, 2023 · EI-STW · No damage NTSB DCA24WA031Incident · No injuriesClass 5 · ForeignBombardier CL600 2D24 · Okiyakpu, NigeriaNov 14, 2023 · 5N-BXR · No damage NTSB 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…Oct 21, 2023 · N52631 · Substantial damage 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.Oct 15, 2023 · N72FU · Substantial damage NTSB GAA24WA057AccidentClass 5 · ForeignPiper PA-31-350 · Sioux Lookout, CanadaOct 14, 2023 · C-GQXD · No damage NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the separation of the main landing gear wheel and the subsequent loss of directional control.Sep 24, 2023 · N2586R · Substantial damage NTSB DCA23WA450IncidentClass 5 · ForeignBoeing 757 · Manchester, United KingdomSep 8, 2023 · G-LSAA · No damage NTSB 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.Aug 22, 2023 · N4111Z · Substantial damage NTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomAug 21, 2023 · G-AYUH · Destroyed NTSB DCA23WA422Accident · No injuriesClass 5 · ForeignATR ATR72 · Gran Canaria, SpainAug 9, 2023 · EC-MVI NTSB DCA23WA413Incident · No injuriesClass 5 · ForeignBoeing 737 · Belfast, United KingdomAug 9, 2023 · G-NPTH NTSB DCA23WA414Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaAug 7, 2023 · YV3158 · No damage NTSB GAA23WA184Accident · 2 fatalClass 4 · ForeignAmerican Champion 8KCAB · Charata, ArgentinaJun 30, 2023 · LV-HWE · Substantial damage NTSB DCA23WA471IncidentClass 5 · ForeignBoeing 737 · Santa Clara, CubaJun 26, 2023 · C-FFPH · Minor damage NTSB DCA23WA351OccurrenceClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesJun 26, 2023 · A6-FNC · Minor damage NTSB 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.Jun 25, 2023 · N528RE · Substantial damage NTSB DCA23WA336OccurrenceClass 5 · ForeignEmbraer ERJ170 · Monterrey, MexicoJun 25, 2023 · N310JZ · No damage NTSB DCA23WA470OccurrenceClass 5 · ForeignAirbus A320 · Vilnius, LithuaniaJun 21, 2023 · OO-SNI · Minor damage NTSB DCA23WA318IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomJun 12, 2023 · G-FDZX · No damage NTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandMay 25, 2023 · VH-IKJ · No damage NTSB 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.May 24, 2023 · N577TZ · Substantial damage NTSB DCA23WA205Incident · No injuriesClass 5 · ForeignBoeing 737 · East Midlands, United KingdomMar 6, 2023 · G-JMCU · No damage NTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaFeb 18, 2023 · VH-?? · No damage NTSB GAA23WA083AccidentClass 5 · ForeignAirbus Helicopters EC175 · Aberdeen, United KingdomFeb 17, 2023 · G-MCSH · Substantial damage NTSB DCA23WA178IncidentClass 5 · ForeignBoeing 737 · Paris, FranceFeb 10, 2023 · TF-BBL · No damage NTSB 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.Jan 31, 2023 · N4811E · Substantial damage NTSB DCA23WA160Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Niederrhein/Weeze, GermanyJan 21, 2023 · 9H-QDU · No damage NTSB 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…Jan 15, 2023 · N9687J · Substantial damage