Final NTSB investigations, 2009

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

Cases per year

20082026
Final NTSB investigations, 2009 per year, 2008–2026: 592 cases
200810
200922
201032
201124
201231
201317
201425
201522
201622
201714
201820
201937
202037
202146
202275
202397
202451
202510

Latest 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 year(c.\"eventDate\") = 2009
    AND c.\"completionStatus\" = 'Completed'
    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 ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).Dec 15, 2009 · N723LJ · DestroyedNTSB 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 damageNTSB 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 damageNTSB 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 damageNTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.Oct 22, 2009 · N2121J · Substantial damageNTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.Oct 21, 2009 · N62635 · Substantial damageNTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.Sep 29, 2009 · N2183P · Substantial damageNTSB 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 damageNTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.Sep 7, 2009 · N65873 · Substantial damageNTSB CEN09CA569Accident · No injuriesData collectionFinal reportCessna T210 · Tulsa, OKA temporary loss of elevator pitch control for undetermined reasons.Sep 7, 2009 · N6442Y · Substantial damageNTSB CEN09CA563Accident · Minor injuriesData collectionFinal reportHalbert James H Rans S-7 · Short, OKA partial loss of engine power for undetermined reasons.Sep 6, 2009 · N615JH · DestroyedNTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.Sep 2, 2009 · N58163 · Substantial damageNTSB 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 damageNTSB 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 damageNTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.Jul 19, 2009 · N5518P · DestroyedNTSB 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 damageNTSB CEN09CA295Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Lisse, TXA total loss of engine power for undetermined reasons.May 8, 2009 · N248LF · Substantial damageNTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damageNTSB CEN09IA254Incident · No injuriesIncident investigationFinal reportBell 206 · Vick, TXUndetermined.Apr 8, 2009 · N295AE · Minor damageNTSB 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 damageNTSB CEN09FA193Accident · 1 fatalField investigationFinal reportBell 206-L4 · Moundridge, KSInflight collision with terrain for undetermined reasons.Mar 8, 2009 · N863H · Substantial damageNTSB WPR09LA149Accident · 1 fatalLimited investigationFinal reportCessna 172N · Oceanside, CAA loss of aircraft control for undetermined reasons.Mar 6, 2009 · N726RJ · Destroyed