IAE V2533-A5
NTSB investigations · 21
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('34611')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('34611')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DCA26LA270Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A321-231 · Somerset, CONTSB ENG26LA019IncidentClass 4 · LimitedInvestigation openAirbus A321 · Baltimore, MDNTSB DCA25LA341Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321 · Las Vegas, NVThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant who was standing at the time of the encounter.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB DCA24LA092Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Boston, MAThe “follow me” driver stopping the airplane (flight 551) about 35 feet from the normal stopping point due to a difficulty in seeing the yellow “T”-bar because of the dark night conditions and the presence of de-icing fluid on the ground.NTSB DCA23LA278Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Charlotte, NCThe captain’s failure to maintain the appropriate airspeed and pitch attitude during landing which resulted in a tailstrike.NTSB DCA21LA176Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Miami, FLan inadvertent encounter with convective turbulence.NTSB DCA21LA164Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · New Orleans, LAAn inadvertent encounter with severe turbulence during cruise flight that caused a flight attendant to fall and fracture his ankle.NTSB DCA19WA216Incident · No injuriesForeign investigationAirbus A321 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Airbus A321 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB DCA19LA134Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · New York, NYThe captain’s excessive left rudder pedal input during the takeoff ground roll, which caused a large heading deviation and a left roll upon rotation that resulted in the left wingtip striking the ground.NTSB DCA18CA294Accident · Serious injuriesData collectionFinal reportAirbus A321 · Dallas, TXa passenger leaving a bag in the aisle that the flight attendant tripped over.NTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.NTSB DCA17CA214Accident · No injuriesData collectionFinal reportAirbus A321 231 · Arlington, VAThe failure N841NNs captain to maintain appropriate clearance from N982VJ, which was stopped on the taxiway.NTSB DCA17WA209Accident · No injuriesForeign investigationAirbus A321 231 · Christ Church, BarbadosThe Barbados Civil Aviation Department has notified the NTSB of an accident involving a AIRBUS A321 231 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Barbados's investigation…NTSB DCA17CA147Accident · No injuriesData collectionFinal reportAirbus A321 231 · Chicago, ILthe A321 flight crew's incorrect evaluation of the clearance between the aircraft, leading to the inadvertent collision with the horizontal stabilizer of the CRJ700. Contributing to the accident was traffic congestion that resulted in the CRJ700 having to…NTSB DCA17WA115Incident · No injuriesForeign investigationAirbus A321 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on February 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB DCA16CA205Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Bermuda, Bermudaan inadvertent encounter with clear air turbulence.NTSB DCA16CA202Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Jamaica, NYan encounter with convective turbulence that resulted in a flight attendant injury.NTSB OPS16IA004Incident · No injuriesIncident investigationFinal reportAirbus A321 231 · Fort Lauderdale, FLThe air traffic controller's failure to ensure the runway surface area was clear of vehicles before clearing an aircraft for takeoff. Also causal was the flight crew's decision to initiate a takeoff while the Runway Status Lights (RWSL) Takeoff Hold Lights…NTSB DCA13FA071Accident · No injuriesField investigationFinal reportAirbus 321 · Las Vegas, NVthe captain's improper recovery from a bounced landing which resulted in a tailstrike.NTSB ERA10LA299Accident · No injuriesLimited investigationFinal reportAirbus A321-231 · Charlotte, NCThe Airbus A330 flight crew's failure to maintain clearance from a standing airplane while taxiing.
Back to IAE V2533-A5