FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20090709012259IPiper PA46350P · Washington, PA(-23) On July 9, 2009 N545JW landed gear up on runway 27 at Washington County Airport (afj).Accident 20090709012199ANamer SNJ5 · Simla, CO(-23) On July 9, 2009 at about 1300 MDT, the ATP rated pilot of N212TC, and SNJ-5 was practicing aerobatics near Simla, Colorado, and apparently lost control and spun into the ground, resulting in a post-flight fire and fatal injuries.Incident 20090709011959IMooney M20K · Denver, CO(-23) During taxi on aircraft parking ramp aircraft left wing struck automobile windshield. The automobile was privately owned and stopped at the time.Incident 20090709011489ICessna 150G · Norfolk, NE(-23) On July 7, 2009, at approximately 2115 CDT, a parachutist jumped from a Cessna 150, N3109J, at 3000 feet MSL over the kofk airport. The parachutist deployed his canopy and performed a spiral maneuver low to the ground. The canopy collapsed and the…Incident 20090708047549ICessna U206G · Galena, AKPilot reported electrical system failure and noticed oil on the windscreen. Pilot elected to land on an available lake as aircraft is float equipped. Aircraft landed without incident. Pilot discovered oil filler cap had not been secured causing oil to leak…Incident 20090708019599ICessna 172 · Suppesville, KSWhile taxiing for takeoff, the instructor looked down to sort out charts. The student lost control of the aircraft and taxiied into a fence. Minor damage, no injuries.Accident 20090708014869ACessna 421C · Tampa, FL(-23) On July 8, 2009 at approximately 1349 EDT, a 1979 Cessna 421C, registration number N4467D, s/n 421C0634, piloted by steve d. barrows was on an IFR flight from tki to tpa, when all radio and radar contact was lost. The pilot and 4 passengers sustained…Accident 20090708013339ABell 47G2 · Turlock, CA(-23) While conducting an aerial application, the aircraft was possible caught into settling with power. The pilot stated that he was performing a climbing 180° left hand turn (ag-turn). As he was climbing he noted that the rotor RPM started to droop but…Accident 20090708013329ACessna 182P · Mammoth Lakes, CA(-23) The aircraft departed runway 27 at Mammoth yosemite airport (mmh) reportedly enroute to fresno yosemite (fat). As it approached Mammoth pass, it was observed by witnesses to be in a low, steep left turn, reversing course. The airacraft struck several…Accident 20090708012839AAmtr VANSRV7A · Sanderson, FL(-23) On July 9, 2009 I was contacted by the southern regional communications center that an aircraft crash was discovered by the floriday fish and wildlife. The FAA made an on site investigation on July 10, 2009. During the investigation it was discovered…Accident 20090708012769AAviat PITTSS2B · Oakland, MSAs indicated by witness the pilot had been performing aerobatic manueveurs over a wooded area as inicated by witnesses. The pilot indicated the aerobatics were performed above 1500'. The pilot indicaated he had leveled the aircraft for cruise at approximately…Accident 20090708011699AAmtr Viggenite · St Louis, MO(-23) The pilot stated the engine failed after turning onto a right downwind for runway 26R at ksus. The pilot attempted a quick restart but to no avail. The airplane landed in the canopy of a tree next to the airport property. The airplane rolled to the…Accident 20090707047769AAir Tractor AT-301 · Brinson, GAWitnesses state that the aircraft was approximately 600 - 700 feet off the ground when the aircraft appeared to be in a slight climb, they saw a white trail of smoke, I believe to be water due to no indication of 200 gallons of water spillage at impact site,…Accident 20090707047609ADouglas ACF DC3 · Hayes River, AKAfter landing on an unimproved strip there was a bump during taxi to the parking area. The lower link from the tailwheel damper assembly to the tailwheel fork failed. The tailwheel fork pivoted forward and the weight of the aircraft forced the tailwheel to go…Incident 20090707017939IMnmite M18L · Ashtabula, OH(-23) After landing the nose gear failed. Minor damage to cowl and nose gear.Accident 20090707013579ACessna T210N · Corona, CA(-23) The PIC landed hard on main gear bounced on nose gear, nose gear retracted, propeller struck runway with engine at power, destroyed propeller, propeller hub and damage to gear doors and engine nacelle. The fire wall is bent, floor structure under pilots…Accident 20090707012809ACirrus SR22 · Winder, GA(-23) [privacy data omitted], right seat, is a CFI and was acting as PIC on IFR departure from kpdk. He was conducting a flight review for [privacy data omitted], who is not instrument rated, who was in the left seat. There was a passenger, [privacy data…Incident 20090707012269IAirtrc AT602 · Newton, IA(-23) The dsm FSDO received an annonymous report via telephone stating an incident occured at the Newton airport on 07/13/2009. An ag tractor AT-602 was started in preparation for taxi and the pilot got out of the airplane. The airplane taxiied across the…Incident 20090707012139ILindst 120A · Louisville, KY(-23) Airman was conducting commercial sight-seeing operations in a hot-air balloon. After passing over cross-country powerlines, pilot initiated approach to land in a large open field. At about 30 feet above the ground, pilot noted another power line…Incident 20090707012009IBoeing 7373H4 · Baltimore, MD(-23) Flt 69 departed on runway #28 @ 1717 hrs and reported hitting a small flock of birds. The pilot requested to return to land tower worked aircraft back towards airport, the pilot requested time to set-up so aircraft was switched to approach. Flight 69…Accident 20090707011879ABell 47G3B2 · Hoquiam, WA(-23) On July 7, 2009 N8169J, owned and operated by farm and forest helicopter service inc. received substantial damage when the pilot allowed the helicopter to settle into the water while programming an ag-nav. The pilot received minor injuries and the…Accident 20090707011729ARans S5COYOTE · Greeneville, TN(-23) Aircraft N284AH departed cooper for greenville municipal airport (gcy) pilot was descending through 2500 ft for gcy when the engine lost power. The pilot restarted the engine, the engine ran for a short time and lost power again. One more attempt was…Incident 20090707011409ICessna 172N · Hermiston, OR(-23) The PIC said he was descending out of 8,000 feet when he started getting a lot of smoke in the cockpit and oil spraying on the wind screen. The pilot said the engine began to run real rough with a low RPM on the tachometer. The PIC was able to glide the…Incident 20090707011089IBeech D95A · Moses Lake, WA(-23) Pilot was making a VFR VOR practice approach to mwh runway 4. He extended the gear for landing and observed the green light and the gear down mechanical indicator for the nose gear. Shortly there after a pop was heard and he lost all electrical power.…Accident 20090707010879ACessna 182Q · Ballinger, TX(-23) On July 7, 2009, N7589S, a Cessna 182Q, departed Colorado city, Texas (T88) enroute to Ballinger, Texas (E30), experienced fuel exhaustion and was forced to land in a field. The pilot could not get fuel at T88, so the pilot attempted to fly to E30 to…Accident 20090707010729AAmtr Kitfox · Santa Clarita, CA(-23) [privacy data omitted] and [privacy data omitted] were on a training flight from whp to the fillmore area, then back to shp. Returning from fillmore, over stevenson ranch, there was a loud bang. The pilots then noticced that the propeller blades had…Accident 20090706047519ABellanca 8GCBC · Palmer, AKAircraft crashed in mountainous terrain after encountering downdraft that it was unable to out perform.Accident 20090706013589APiper PA28140 · Taylor, AZ(-23) Pilot reported that he performed a short field takeoff from the airport and that following lift off, the aircraft did not seem to be performing as expected and did not climb as expected. Pilot attempted precautionary landing, striking a tree and…Incident 20090706012649IUnivar 1081 · Villa Rica, GA(-23) Pilot was conducting local flight out of Stockmar Airport (20GA) after aircraft returned from annual inspection. Made one touch and go on rwy 28 without incident. On second touch and go, when tailwheel lowered to runway a severe shimmying began with an…Accident 20090706011599AMooney M20J · Midland, TX(-23) On July 6, 2009 at approximately 1540CDT, the pilot of N201FD, a Mooney M20J, during a flight from san angelo, Texas (sjt), executed a gear up landing on runway 34 at Midland Airpark (mdd) in Midland, Texas. The aircraft slid for approximately 900 feet…Accident 20090706010609ACessna 182M · Wilson Bar, IDPilot and passenger were landing at Wilson Bar, ID back country usfs airstrip to camp. Pilot encountered updrafts at the approach end of the runway, landed long and ran out of runway. Aircraft ended up in trees and rocks. Aircraft substantially damaged. Minor…Incident 20090706009929IBlanca 14132 · Newburyport, MADistribution: original AEA-230 faast manager, EA-61 file, AAI-200 (via fax: 202-267-5043, AFS-620, AEA-530. See attached narrative sheet: N74378, Bellanca cruisair senior, BL-1413-2, landed hard at Plum Island Airport (2B2) Newburyport mass, at 14:08 EDT,…Incident 20090705047619ICessna 310N · Fort Meyers, FLOn approach to eyw (key west) the gear was selected to the down position, the pilot heard an ususual sound and then noticed there was no green nose landing gear down light on. He did a fly-by the tower and the tower stated it appeared the nose gear was not…Accident 20090705047569ACessna A185F · Skwentna, AKFloat equiped aircraft landed hard on lake in glassy water conditions.Incident 20090705047509IMcdonnell D DC-9-82(MD- · Birmingham, ALThe pilot taxied around a stopped aircraft and came into the gate to the right of the taxi line. The marshaler was trying to get the aircraft back on the taxi line and was not watching the right wing walker. The right wing walker tried to get the aircraft to…Accident 20090705017959ACessna 210L · Lansing, MI(-23) At 1707Z on 5th July 2009. Pilot [privacy data omitted] landed N4625Q a CE-210 gear up on runway 28R at klan airport. The pilot had done three patterns at garnd haven airport. On the fourth pattern the gear did not come down so the pilot checked the…Accident 20090705013319ACessna 150J · South Lake Tah, CA(-23) South Lake Tahoe Airport is situated at an elevation of 6264 ft. with a temperature 79 degrees f, the density altitude was approximately 8691 ft, seconds after lifting off from runway 18, the Cessna entered an uncontrolled descent and impacted terrain…Accident 20090705013199APilats PC1245 · Raphine, VA(-23) On July 5, 2009 at 1004 eastern daylight time, N578DC, a Pilatus PC12/45 aircraft crashed near Raphine, VA. The pilot told air traffic control that he required radar vectors because he had "lost my panel." Moments later the aircraft descended rapidly…Accident 20090705011829AAmtr Murphyrebel · Idaho Falls, ID(-23) Pilot conducted ground runups on the engine and systems before taking the active runway for take-off, these runups went smoothly and no problems occured. After being cleared for take-off, the pilot applied power and the aircraft began its take-off roll,…Accident 20090705011779ACessna 180 · La Grande, OR(-23) Pilot encountered sudden wind shear during takeoff roll, causing loss of control while aborting takeoff, with aircraft veering off the runway and coming to rest upside down. Local automated weather reported light winds, although witnesses at airport…Accident 20090705011549AAmtr Challengerii · Forest City, PA(-23) Operated under 14 CFR part 91 pilot state that he allowed to let the aircraft get to slow due inadequately managing airspeed. When james parker attempted to flare the aircraft, however due to lack of airspeed the aircraft stalled and struck the ground.Incident 20090705011379IEMB EMB120 · Denver, CO(-23) Aircraft was parked at gate A52. Flight crew turned on power to the aircraft. Aircraft landing gear retracted on ground. No passengers were on the aircraft.Incident 20090705011199IMooney M20F · Portland, OR(-23) Commerical/instrument (1200 hour pilot) and another eye witness saw the aircraft make a hard landing on the main gear and then bounce several feet up in the air. Aircraft floated above runway for about 50 feet, and then came down hard on the nose with…Accident 20090705009429ABoeing A75N1 · Tacoma, WA(-23) On July 5, 2009 N1431C, owned and operated by [privacy data omitted] received substantial damage when it ground looped after landing on runway 17 at the Tacoma Narrows Airport, Tacoma Washington. [privacy data omitted] And his pilot rated passenger…Accident 20090704053979ANorth Ameri T-28B · Waxahachie, TXOn July 4, 2009, at 0920 central daylight time, a North American T-28, N28NB, operated by [privacy data omitted], received substantial damage on impact with terrain during a forced landing near midlothian regional airport in Waxahachie, TX. The airline…Incident 20090704047699IChampion 7ECA · Talkeetna, AKThe pilot-in-command was making a visual approach to runway 36 at Talkeetna. The final approach to landing was reported as normal and stabilized by the pilot. When the aircraft touched down, the pilot reported the aircraft bounced. Power was added in an…Accident 20090704025249AAirborne Edge 582 TR · Fairbanks, AKPilot stated that he was practicing taxing at a residential location and became Airborne, he then proceeded to metro field and while attempting to land encountered a strong downdraft or windshear. Aircraft was substantially damaged, pilot recieved minor…Accident 20090704021669AAerovd L29 · Tehachapi, CAOn July 4, 2009, at approximately 1330 PDT, an aero vodochody L-29, N97869, impacted the ground on old town road in Tehachapi, California. Both occupants of the aircraft were pronounced dead at the scene by the kern county corner's office. The accident site…Accident 20090704017689AWohnou Teamzmax · Iowa, LA(-23) Pilot departed airfiled to the north with a known crack in the wooden propeller. At about 500 feet, he felt a severe shaking and saw the propeller disinegrate. He turned in an attempt to return to the grass runway. To avoid the traffic on interstate 10,…Accident 20090704016669AConaer LA4200 · Racine, WIPilot made multiple landings near wind point, Racine , WI in N56LA, a lake a/c. sea conditions were calm. Wind conditions were calm. Upon landing on the 6th landing, pilot hit log or wave and aircraft sponson broke away from aircraft. Unable to taxi aircraft,…