NTSB investigations: Airbus Industrie A319-131
7 cases on aircraft the registry lists as Airbus Industrie A319-131. 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.
Cases per year
| 1999 | 1 |
|---|---|
| 2002 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2025 | 2 |
Where
Open the mapLatest cases
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3930317'))
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 ('3930317'))
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 DCA25LA268Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A319-131 · Santa Barbara, CAThe ramp worker’s premature entry into the jet blast hazard area of an operating engine due to his failure to maintain situational awareness and his misinterpretation of the marshaller’s hand signals.NTSB DCA25LA114Occurrence · No injuriesClass 3 · LimitedFinal reportAirbus Industrie A319 · Houston, TXThe failure of the cabin crew to activate the evacuation alarm and to maintain coordinated communication with the flight crew following the cabin crew’s decision to command an evacuation, which resulted in an engine running during the initial evacuation.…NTSB DCA11FA053Accident · Serious injuriesField investigationFinal reportAirbus A319 · Chillicothe, MOAn inadvertent encounter with unforecast convective turbulence.NTSB DCA10IA021Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Newark, NJA mechanical failure of internal components of the right main landing gear door actuator resulting in the flight crew being unable to fully extend the right main landing gear using the normal and alternate procedures. Contributing to this incident was a…NTSB DEN06LA095Accident · Serious injuriesLimited investigationFinal reportAirbus A319-131 · Masonville, COthe flight's encounter with unexpected turbulence, which resulted in a passenger sustaining a fractured ankle.NTSB CHI03IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Chicago, ILThe maintenance facililty improperly assembled and installed the nose landing gear shock absorber assembly. Factors were the improper assembly which allowed the nose gear to turn 90 degrees to the direction of travel.NTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.