Final NTSB investigations
4 cases where NTSB found Wing auxiliary structure.
Cases per year
| 2008 | 1 |
|---|---|
| 2021 | 1 |
| 2024 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01035720'))
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035720')) 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 DCA24FA299Accident · Minor injuriesClass 3 · FieldFinal reportAirbus A350-941 · College Park, GADelta Air Lines flight crew’s loss of situation awareness of the clearance between their right wingtip and the empennage of an Endeavor Air airplane holding on a perpendicular taxiway, resulting in their wingtip colliding with the other airplane’s empennage.…NTSB DCA24LA245Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Salt Lake City, UTDelta Air Lines flight 2046 flight crew's incorrect evaluation of the clearance between their airplane and Delta Air Lines flight 2046 as they turned onto a perpendicular taxiway.NTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…NTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…