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.

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…Apr 20, 2014 · XA-UKR · DestroyedNTSB 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…Apr 10, 2014 · B-7475 · Substantial damageNTSB 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…Apr 9, 2014 · N395P · Substantial damageNTSB 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…Apr 5, 2014 · N229P · Substantial damageNTSB 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…Apr 5, 2014 · G-OJMF · DestroyedNTSB 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…Apr 4, 2014 · D-ASXG · No damageNTSB 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…Mar 19, 2014 · ZK-HQP · Substantial damageNTSB 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.Mar 11, 2014 · N98EV · Substantial damageNTSB 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…Mar 7, 2014 · N149WA · Substantial damageNTSB 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…Mar 5, 2014 · JA3853 · DestroyedNTSB 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…Mar 2, 2014 · VH-ZMH · DestroyedNTSB CEN14CA155Accident · No injuriesData collectionFinal reportCessna 172M · South Bend, INThe pilot involved and the phase of flight when the damage was incurred were not determined.Feb 26, 2014 · N9801V · Substantial damageNTSB 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…Jan 20, 2014 · YR-BNP · DestroyedNTSB 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…Jan 19, 2014 · PK-IWT · DestroyedNTSB ERA14WA100Accident · 2 fatalForeign investigationCessna 208B · Olive Creek, GuyanaJan 19, 2014 · 8R-GHS · Destroyed