NTSB investigations, 2009, KS

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 2009, KS per year, 1963–2026: 2,834 cases
19632
1964134
1965112
1966134
1967136
1968109
1969106
197092
197191
197281
197365
197484
197584
197691
197785
197867
197983
198060
198171
198259
198363
198449
198555
198652
198735
198836
198916
199035
199128
199223
199325
199432
199533
199630
199730
199822
199932
200020
200114
200219
200320
200425
200518
200619
200724
200827
200919
201018
201115
201222
201324
201415
201524
201620
201718
201817
201919
202011
202115
202215
202321
202413
20259
202611

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.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
  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 CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.Dec 6, 2009 · N108L · Substantial damageNTSB CEN10CA018Accident · Minor injuriesData collectionFinal reportCessna T206H · Johnson City, KSThe pilot's delayed action in applying full power during a go-around after flying into a fog bank.Oct 16, 2009 · N454TG · Substantial damageNTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.Sep 26, 2009 · N9204E · Substantial damageNTSB CEN09LA594Accident · No injuriesLimited investigationFinal reportMcclish Funk B85C · Coffeyville, KSAn in-flight fire for undetermined reasons.Sep 18, 2009 · N81167 · DestroyedNTSB CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.Aug 29, 2009 · N8312G · Substantial damageNTSB CEN09CA507Accident · Serious injuriesData collectionFinal reportBoeing A75L300 · Salina, KSThe pilot's failure to maintain directional control during a touch-and-go.Aug 10, 2009 · N75263 · Substantial damageNTSB CEN09CA473Accident · Minor injuriesData collectionFinal reportStinson 108 · Gardner, KSThe pilot's failure to ensure that the fuel selector valve was set properly in its detent prior to takeoff, resulting in fuel starvation.Jul 21, 2009 · N192C · Substantial damageNTSB CEN09CA395Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Pittsburg, KSThe pilot's loss of directional control resulting in a ground-loop.Jun 27, 2009 · N702KB · Substantial damageNTSB CEN09CA300Accident · Minor injuriesData collectionFinal reportDiamond DA20 · Olathe, KSThe student pilot's improper landing flare and recovery from a bounced landing, as well as his improper decision to continue the takeoff after striking the propeller on the runway.May 14, 2009 · N926AF · Substantial damageNTSB CEN09CA251Accident · Minor injuriesData collectionFinal reportAviat A-1B · Great Bend, KSThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions.Apr 15, 2009 · N84DT · Substantial damageNTSB CEN09FA220Accident · No injuriesField investigationFinal reportCessna E162 · El Dorado, KSThe failure of the Ballistic Recovery System to disconnect due to twisted attachment straps.Mar 19, 2009 · N162CE · Substantial damageNTSB CEN09CA212Accident · No injuriesData collectionFinal reportPiper PA28-151 · Gardner, KSThe pilot's failure to ensure adequate clearance between the airplane's right wing and the building.Mar 15, 2009 · N43181 · Substantial damageNTSB CEN09FA193Accident · 1 fatalField investigationFinal reportBell 206-L4 · Moundridge, KSInflight collision with terrain for undetermined reasons.Mar 8, 2009 · N863H · Substantial damageNTSB CEN09LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Johnson County Exec Airport, KSFailure of the pilot of the Cessna 172S to ensure the taxiway was clear prior to initiating the turn. Contributing to the accident was the failure of the pilot of the Cessna 172N to obtain taxi clearance prior to entering the movement area.Feb 25, 2009 · N734WD · 2 aircraft · Substantial damageNTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.Feb 22, 2009 · N733FR · Substantial damageNTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.Feb 7, 2009 · N2333D · Substantial damageNTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…Jan 30, 2009 · N345JB · Substantial damageNTSB CEN09CA141Accident · No injuriesData collectionFinal reportCessna 172S · Emporia, KSThe pilot's inadequate compensation for the wind conditions during the touch-and-go. Contributing to the accident were the gusty crosswinds.Jan 18, 2009 · N2465H · Substantial damageNTSB CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.Jan 7, 2009 · N131DL · Destroyed