NTSB investigations, 2014
65 cases where the sequence of events included Unknown or undetermined.
Cases, 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_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 year(c.\"eventDate\") = 2014
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2014 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN14RA212Accident · 8 fatalForeign investigationBritish Aerospace HS 125 700A · Saltillo, MexicoOn April 19, 2014, about 1945 hours central daylight time, a British Aerospace HS 125 700A, XA-UKR, impacted an industrial complex and terrain while on final approach to Plan de Guadalupe International Airport (SLW), near Saltillo, Mexico. A postimpact ground…NTSB WPR14WA189Accident · 1 fatalForeign investigationBell 407 · Beijing, P.R. China, ChinaOn April 10, 2014, at 0323 universal coordinated time, a Bell 407GX, B-7475, was substantially damaged when it impacted water under unknown circumstances near Beijing, P.R. China. The helicopter was operated by Eastern General Aviation Limited Corporation…NTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…NTSB ERA14FA464Accident · 1 fatalField investigationFinal reportFortuna Dave Sonex · Dunnellon, FLThe in-flight collision with a tree in a heavily wooded area during controlled flight while the pilot was attempting a forced landing for reasons that could not be determined based on the available evidence. Contributing to the delay in locating the wreckage…NTSB CEN14WA190Accident · 1 fatalForeign investigationEnstrom 280 - FX · Kirchham, Austria, AustriaOn April 5, 2014, about 1754 UTC, an Enstrom 280FX Shark helicopter, G-OJMF, (s/n 2086) impacted terrain near Kirchham, Austria. The helicopter was destroyed, the pilot was fatally injured, and the two passengers on board the helicopter were seriously…NTSB DCA14WA109Incident · No injuriesForeign investigationBoeing 737-800 · Kayseri, TürkiyeThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on April 4, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under…NTSB WPR14WA148Accident · 1 fatalForeign investigationMD Helicopter 500N · Gisborne, New Zealand, New ZealandOn March 19, 2014, at 2030 universal coordinated time, a MD Helicopters 500N, ZK-HQP, was preparing for a fire lighting operation when it crashed in Hawkes Bay near Gisborne, New Zealand. The helicopter was operated by Gisborne Helicopters Limited under the…NTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.NTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…NTSB ANC14WA019Accident · 2 fatalForeign investigationCessna 172M · Toyota City, JapanOn March 5, 2014, at 1235 Japan standard time, a single engine Cessna 172M, Japan registered JA3853, sustained substantial damage after impacting terrain near Toyota City, Aichi Prefecture, Japan. Both occupants sustained fatal injuries. This report is for…NTSB WPR14WA126Accident · 1 fatalForeign investigationAmateur Built VAN'S RV-6 · Gatton Airpark, Australia, AustraliaOn March 2, 2014, at 0747 local time, a Van's RV-6, VH-ZMH, collided with an embankment and was destroyed by a postimpact fire near Gatton Airpark, Australia. The flight was operated by the pilot under the pertinent civil regulations of the government of…NTSB CEN14CA155Accident · No injuriesData collectionFinal reportCessna 172M · South Bend, INThe pilot involved and the phase of flight when the damage was incurred were not determined.NTSB CEN14WA117Accident · 7 fatalForeign investigationBritten Norman BN-2A-27 · Horea, RomaniaOn January 20, 2014, about 1400 coordinated universal time, a Britten-Norman BN-2A-27 airplane, YR-BNP, impacted mountainous terrain near Horea, Cluj, Romania. The two pilots, and five passengers were all fatally injured. The airplane was destroyed. The…NTSB WPR14WA108Accident · 4 fatalForeign investigationPiper PA31 - 350 · Maluku, Indonesia, IndonesiaOn January 19, 2014, at 1220 local time, a Piper PA-31-350, PK-IWT, collided with terrain under unknown circumstances while on approach to Dumatubun Airport, Maluku, Indonesia. The pilot and three passengers were fatally injured and the airplane was…NTSB ERA14WA100Accident · 2 fatalForeign investigationCessna 208B · Olive Creek, Guyana