NTSB investigations: Airbus A320-233

4 cases on aircraft the registry lists as Airbus A320-233. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20112026

NTSB investigations: Airbus A320-233 per year, 2011–2026: 4 cases
2011	1
2017	1
2020	1
2023	1

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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940329')) 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940329'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3940329'))
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 DCA23WA291Incident · No injuriesClass 5 · ForeignAirbus A320-233 · Monterrey, MexicoMay 11, 2023 · N518VL · Minor damage NTSB ENG20WA037Incident · No injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe Mexican government has notified the NTSB of an incident involving an Airbus A330-202 that occurred June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the Direccion de Analisis de Accidentes e Incidentes de Aviacion (DGAC) of…Jun 16, 2020 · N526VL · No damage NTSB DCA17WA189Incident · No injuriesForeign investigationAirbus A320 233 · Lima, PeruThe Comisión de Investigación de Accidentes de Aviación (CIAA) of Peru has notified the NTSB of an incident involving a AIRBUS A320 233 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…Aug 27, 2017 · N491TA · No damage NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…Sep 19, 2011 · N493TA · No damage