NTSB investigations, 2009

8 cases where NTSB found Miscellaneous.

Cases per year

20082026
NTSB investigations, 2009 per year, 2008–2026: 78 cases
20082
20098
20106
20115
20125
20136
20142
20159
20164
20173
20185
20192
20202
20214
20224
20233
20248

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0205'))
  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 DCA10CA018Accident · Minor injuriesData collectionFinal reportBombardier CL600 2C10 · Dallas, TXThe fueler's falling asleep in the fueling truck with the truck in neutral and without the parking brake set, which allowed the truck to roll until it impacted the airplane.Dec 18, 2009 · N515AE · Substantial damageNTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.Nov 8, 2009 · N6644 · DestroyedNTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.Sep 29, 2009 · N2183P · Substantial damageNTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.Sep 16, 2009 · N2594M · Substantial damageNTSB CEN09CA421Accident · No injuriesData collectionFinal reportPitts S-2A · Springfield, ILThe pilot's inability to maintain directional control while landing due to the unintentional obstruction of the rudder by the passenger.Jul 8, 2009 · N18BT · Substantial damageNTSB CEN09CA186Accident · Minor injuriesData collectionFinal reportBeech A36 · Athens, TXThe non-certificated pilot's failure to maintain control during his unauthorized use of the airplane.Mar 4, 2009 · N5470V · Substantial damageNTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.Feb 17, 2009 · UNREG · Substantial damageNTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.Jan 12, 2009 · N428DC · Substantial damage