NTSB investigations, MA
8 cases where NTSB found Perception/orientation/illusion.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 2 |
| 2015 | 1 |
| 2018 | 1 |
| 2021 | 1 |
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.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020220'))
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."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020220')) 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 ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.NTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.NTSB ERA15FA254Accident · 3 fatalField investigationFinal reportBeech A36 · Plainville, MAThe total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.