Skip to content

NTSB investigations, 2009

31 cases where the sequence of events included Unknown or undetermined.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2009 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

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\") = 2009
    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") = 2009
  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 ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).Dec 15, 2009 · N723LJ · Destroyed NTSB WPR10WA070Accident · 4 fatalForeign investigationRobinson R44 · Netanya, Israel, IsraelThe accident is under the jurisdiction of, and is being investigated, by the State of Israel, Ministry of Transport, Aviation Incidents and Accidents Investigation (AIAI).Nov 24, 2009 · 4X-BDM · Substantial damage NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.Nov 8, 2009 · N4139X · Substantial damage NTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.Nov 5, 2009 · N120FB · Substantial damage NTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.Nov 4, 2009 · N725GS · Substantial damage NTSB ERA10WA035Accident · 5 fatalForeign investigationHawker BAe-125-800B · Minsk, BelarusOn October 26, 2009, at 1934 universal coordinated time (2134 local standard time), a Hawker-Beech BAe-125-800, Russian registration RA-02807, operated by S-Air, was destroyed when it impacted forested terrain during a go-around attempt at Minsk-2…Oct 26, 2009 · RA-02807 · Destroyed NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.Oct 22, 2009 · N2121J · Substantial damage NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.Oct 21, 2009 · N62635 · Substantial damage NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.Sep 29, 2009 · N2183P · Substantial damage NTSB ERA09WA519Accident · 2 fatalForeign investigationRobinson R44 · Perm, RussiaOn September 14, 2009, at 0700 Universal Time Coordinated, a Robinson R44-II, Russian registration RA-04289, operated by Geliks Airline, crashed 6.2 miles from the Perm Airport, Perm, Russia. The pilot and passenger were killed, and the helicopter sustained…Sep 14, 2009 · RA-04289 · Substantial damage NTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.Sep 13, 2009 · N555BB · Substantial damage NTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.Sep 7, 2009 · N65873 · Substantial damage NTSB CEN09CA569Accident · No injuriesData collectionFinal reportCessna T210 · Tulsa, OKA temporary loss of elevator pitch control for undetermined reasons.Sep 7, 2009 · N6442Y · Substantial damage NTSB CEN09CA563Accident · Minor injuriesData collectionFinal reportHalbert James H Rans S-7 · Short, OKA partial loss of engine power for undetermined reasons.Sep 6, 2009 · N615JH · Destroyed NTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.Sep 2, 2009 · N58163 · Substantial damage NTSB WPR09LA413Accident · Serious injuriesLimited investigationFinal reportAntares US MA-34R · San Jose, CAThe pilot's failure to maintain aircraft control during engine startup, which resulted in a collision with parked aircraft. Contributing to the accident was the engine's inadvertent increase to high power for undetermined reasons.Aug 24, 2009 · N2356W · Substantial damage NTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.Jul 27, 2009 · N1494X · Substantial damage NTSB ANC09WA071Accident · 2 fatalForeign investigationPiper PA-46-31P · Kamsack, CanadaOn July 19, 2009, about 2100 central standard time, a Piper PA-46-31P airplane, Canadian registration C-GUZZ, crashed on takeoff from Kamsack, Saskatchewan, Canada. Two people aboard received fatal injuries, and the remaining two people aboard received…Jul 20, 2009 · C-GUZZ · Substantial damage NTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.Jul 19, 2009 · N5518P · Destroyed NTSB ERA09LA410Accident · No injuriesLimited investigationFinal reportRobinson R44 · Silver Spring, PAThe student pilot's inability to fully control the helicopter, during cruise and the resultant off-field hard landing.Jul 19, 2009 · N25VH · Substantial damage NTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…May 10, 2009 · N502TC · Destroyed NTSB CEN09CA295Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Lisse, TXA total loss of engine power for undetermined reasons.May 8, 2009 · N248LF · Substantial damage NTSB DCA09WA060Accident · 7 fatalForeign investigationBoeing 737 · Kwilu, Bandundu, Congo - KinshasaOn April 29, 2009, about 0800 UTC, TL-ADM, a Boeing 737-200, operated by Bako Air of the Central African Republic, a ferry flight, crashed at the locality of Massamba, District of Kwilu, province of Bandundu, Democratic Republic of Congo. All seven occupants…Apr 29, 2009 · TL-ADM · Destroyed NTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damage NTSB CEN09IA254Incident · No injuriesIncident investigationFinal reportBell 206 · Vick, TXUndetermined.Apr 8, 2009 · N295AE · Minor damage NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…Mar 29, 2009 · N708M · Minor damage NTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneMar 8, 2009 · PT-LKH · Destroyed NTSB CEN09FA193Accident · 1 fatalField investigationFinal reportBell 206-L4 · Moundridge, KSInflight collision with terrain for undetermined reasons.Mar 8, 2009 · N863H · Substantial damage NTSB WPR09LA149Accident · 1 fatalLimited investigationFinal reportCessna 172N · Oceanside, CAA loss of aircraft control for undetermined reasons.Mar 6, 2009 · N726RJ · Destroyed NTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.Feb 16, 2009 · HP-1367 RS · Substantial damage NTSB ERA09WA166Accident · 24 fatalForeign investigationEmbraer EMB110 · Coari, BrazilOn February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…Feb 7, 2009 · PR-SAE · Destroyed