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.
Accident 20090514857419ACessna 152 · West Memphis, ARWhile practicing simulated emergency approach and landings, the aircraft struck an object while in flight. Suspected wire strke based on phase of flight and witness marks on aircraft. Wire strike occured while in flight in the practice area near West Memphis…Accident 20090514047069APiper PA-22/20 · Talkeetna, AKThe pilot and owner of a tri-pacer PA-22/20 was on a pleasure flight from merrill field to Talkeetna with his wife, mother and daughter. Upon landing at Talkeetna, tka, the tail wheel had a bad shimmy. The pilot pushed forward on the control yoke to get the…Incident 20090514017469IWaco ZPF7 · St Teresa, FL(-23) Enroute from apalachiola regional airport (FL) to cross city airport (FL), pilot noticed oil pressure fluctuating. Shortly afterward pilot experienced a sudden engine power loss at 2500 feet 5 miles from wakulla county airport.Incident 20090514010729IBoeing 7373TO · Newark, NJ(-23) 21A. After departure from ewr enroute to atl the coffee maker malfunctioned during the brewing process resulting in hot grounds being ejected and hitting a flight attendant. The injuries resulted in the pilot deciding to return to the departure airport,…Incident 20090514010269IBoeing 737 · Newark, NJ(-23) 21A. After departure from ewr enroute to atl the coffee maker malfunctioned during the brewing process resulting in hot grounds being ejected and hitting a flight attendarnt. The injuries resulted in the pilot deciding to return to the departure…Accident 20090514007959ADiamon DA20C1 · Olathe, KS(-23) On return from a local solo flight in the practice area conducted under visual flight rules, [privacy data omitted], a student pilot, was practicing landings at Johnson County Executive Airport (ojc) runway 18. On his second touch-and-go landing, he…Incident 20090514007399ICessna 172M · San Carlos, CA(-23) Student pilot, on return from his first solo cross country flight, was caught by a wind gust. Reported right cross winds at the time were 12/G28. The right aircraft main tire struck a right runway edge light on landing roll out. Discussed the incident…Incident 20090514007029IBeech P35 · Long Beach, CA(-23) A Beech bonanza, BE-35P, N9657Y, s/n D-7072, declared emergency and landed gear up at Long Beach, CA, airport runway 25R at approximately 0914 PDT on 05/14/2009. Minor damage to propeller, undercarriage and landing gear. No injuries to soul occupant.Accident 20090514006799ACessna R182 · Collins, MS(-23) Aircraft N7392S right wing hit an antenna tower in the Collins, MS area as the pilot in command (PIC) ended his pipeline patrol.Incident 20090514006719IAyres S2R · Monroe, LA(-23) Aircraft was spraying a crop field on the south end of the mlu airport. The aircraft was on its last spray run going east and when the pilot pulled up, the vertical stabilizer snagged a electric power line. The aircraft rear section of the fuselage…Accident 20090514006659AAmrgen AA5B · Midland, TXOn may 14, 2009, at approximately 1400 local time, the student pilot operating N225BC, Grumman aircraft model AA-5B, attempted a takeoff on runway 7 at Midland Airpark (mdd), Midland, Texas. The pilot lost control of the aircraft shortly after rotation. The…Incident 20090514006609IPiper PA18A150 · Midland, TX(-23) On may 14, 2009, at 7:30 CDT, the pilot was cleared to taxi 17R via taxiway charlie from the tie-down ramp at abilene aero. While still on taxiway charlie, a parallel taxiway to 17R, and approaching charlie - 4, he unexpectedly came upon a hold short…Incident 20090514006589ICessna 172RG · North Kingstow, RIThe subject aircraft while pre-departure taxiing via taxiing via taxiiway romeo at Quonset RI, was caught in the jetwash of a C-130 running up in the maintenance area. The left wing of the aircraft was lifted causing the aircraft subsequently to nose over and…Incident 20090513047019ICessna 140 · Fairbanks, AKPilot stated that while he attempted to conduct a crosswind landing he failed to input sufficient aileron input in the upwind side and the left wing touched the pavement. He also stated that he mistakenly removed power over the threshold and subsequently did…Accident 20090513017439ABell UH1B · Richvaille, CA(-23) During a repositioning flight the pilot lost control of the aircraft and it struck a hanger. The aircraft was substantial damaged. The pilot received serious injuries. No other injuries were reported. No evaluation of the aircraft systems have been…Accident 20090513012569AFlight CT2K · Mitchell, SD(-23) On may 13, 2009 a light sport aircraft departed a private strip in maple plain, MN with a final destination to dalhart, TX (dht). While making a fuel stop in Mitchell, SD the aircraft experienced a hard landing due to gusting winds. On impact the…Incident 20090513010949IAmtr Searey · Howie In The H, FL(-23) After landing on the water, 90 degree wind gust raised right wing which caused a/c to pitch to the left and collapse left float allowing hull to rotate over and filling cockpit with water as a/c came to a stop. A/c was 1/2 submerged but remained…Incident 20090513009569IBeech 58TC · Macon, GA(-23) On Wednesday 5/13/2009 @ 1437 EST aircraft N858TC landed @ mcn airport runway 5. During landing sequence the nose gear and right main landing gear retracted causing aircraft to veer off runway into grass. Pilot and 1 passenger on board no injuries…Incident 20090513008829ICndair CL6002B19 · Pittsburgh, PA(-23) Northwest airlink flight 2184, a CL-600-2B19, enroute to boston, Massachusetts, diverted to pittsburg international airport (pit) and landed on runway 10R due to a smoke indication in the lavatory. The ARFF responded and no evidence of fire was found.…Incident 20090513008449IMaule M6235 · Baudette, MN(-23) Aircraft N797PS a Maule 6-235 departed pine river on 05-13-09 on an IFR flight plan bound for wheeler's point on the rainy river just north of Baudette, MN. Weather information from princeton fss indicated the presence of intermittent strong gusty winds…Accident 20090513006979AAmtr CH701 · Oakdale, CA(-23) On approach to rwy 28, winds were gusty from the nw but PIC thought they were within his and the aircraft's limitations. He admits being too slow, just above a stall, when he was "blown off centerline". He ended up landing in rough grass on the left…Accident 20090513006769ANorwn Apachesport · Franklinton, LA(-23) FSDO notificaton given to accident reported at Franklinton Airport (2R7) on 13 may 2009 @ 10:32. Disptached enroute to Franklinton Airport, Louisiana and arrived on scene @ 13:25 on 13 may 2009. Aircraft was relocated prior to dispatch to accident…Accident 20090513006359ACessna 170B · Roswell, NMOn April 13, 2009, the pilot/owner of N3210 departed from his base in artesia, new Mexico (kats) and a VFR flight to Roswell, new mexio (krow). No flight plan was filed. The pilot received ATIS information and, at 1432Z, was cleared to land on runway 35 while…Incident 20090512053159IBoeing 737-3H4 · Houston, TXOn may 12, 2009, at 1946 central daylight time, a Boeing 737-3H4 airplane, N371SW, operated by southwest airlines co. as flight 519, landed at the William p. Hobby airport (khou) Houston, Texas. During the landing on runway 22 (7,602 feet by 150 feet) , the…Accident 20090512047139ARobinson He R44 · Iliamna, AK(Note: narrative subject to amendment as investigation proceeds - sjs 06/02/09.) Aircraft was loaded with-in 50 lbs of gross wieght, with CG located 1 inch forward of the forward CG limit. While in cruise flight and at approximately 100 KIAS, "chugging" of…Accident 20090512022319AAmtr Bearhawk · Round Mountain, NVThe pilot stated; he attempted takeoff when crosswind conditions existed. An abrupt change in the direction occurred just before liftoff and he was unable to apply sufficient correction. The right wingtip struck the ground and the airplane landed hard off the…Incident 20090512007039IAmtr LANCAIR360 · Santa Ana, CA(-23) Santa Ana, CA (sna): experimental amateur built Lancair 360, N8AZ, s/n 327, failed to lower gear and landed gear up on John Wayne-Orange county airport runway 19L at 1900PDT on 05/12/2009. No injuries to sole pilot on board, minor damage to aircraft…Incident 20090512006909ICessna 550 · San Francisco, CA(-23) Flight crew followed emergency procedures for engine out on landing.Incident 20090512006479IDiamon DA20C1 · Pittsburgh, PA(-23) Pilot landed on runway 31 and bounced several times striking and damaging the propeller on the runway. The pilot then advised ATCT, that he was going around and reported a rough running engine. The aircraft landed on runway 10 and was towed back to the…Accident 20090511025179ACessna 170B · Kenai, AKAircraft landing runway 19R at Kenai muni (paen), at 1530 AKDT. Right wing came up then hit ground, left main gear collapsed and then acft came to a stop on its left side.Accident 20090511010689APiper PA28140 · Danville, PA(-23) Student pilot stalled aircraft over runway approximately 30' high. Aircraft contacted the runway in a nose low, left wing down attitude. Nosewheel and tire destroyed, prop contacted runway. Pilot sustained a severe back injury.Incident 20090511006859IBoeing 747446 · Los Angeles, CA(-23) After push back and disconnect from tow tractor aircraft began taxi from spot on taxiway "c" to turn right on taxiway "q". Ground support tug towing 4 dollies came to a stop in the intersecting service road crossing taxiway "c" to await an opportunity…Accident 20090511006789ACessna 172N · Springdale, AR(-23) On may 11, 2009, at 1913 CDT, a Cessna CE-172N, N73842, landed runway 18, yawed slightly left, student pilot attempted to correct with right rudder/brake then added power to execute to go-around; aircraft turned hard right, ran across parallel…Incident 20090511006649ICessna 172RG · Wichita, KS(-23) Pilot was conducting landing practice in the pattern at Wichita mid-contient airport (kict) in preparation for the commercial pilot practical test. During the takeoff roll on runway 1L the pilot inadvertently placed the gear lever in the up position at…Incident 20090510009969IRaven S60A · Albuquerque, NM(-23) On may 10, 2009 at 0730 MDT, N120RB, an Aerostar international balloon, struck the montano bridge over the rio grande in northern Albuquerque, NM. Neither the two passenger nor the commercial pilot were injured. Both the north side bridge rail and the…Accident 20090510009539AAmtr Rotorwayexec · Brookeland, TX(-23) On 05/10/2009 a approximately 2:00 pm local time the owner/pilot of N602DB was hovering in his rotorway exec on his personal properly. The pilot reported that while hovering a few feet off the ground a gust of wind shoved the helicopter sideways causing…Accident 20090510009259ACessna 140 · Mesquite, NV(-23) During landing rollout transitioning from runway 01 at K67L the aircraft experienced an uncontrolled left turn exiting the runway and taxiway environment. The pilot was unsuccessful in countering the turn with use of left rudder and the aircraft…Accident 20090510008729ACessna U206E · Marysville, CA(-23) Aircraft departed Marysville calif (myv) at approximately 12:30 pm on 5/10/2009. The weather was VFR intended route of flight was sightseeing in the local area. At approximately 1:10 pm PST. The aircraft experienced an engine malfucntion. There was a…Incident 20090510008389IMaule M6235 · Poplar Grove, IL(-23) Rockford airport was reporting winds 300 @ 12 knots gust 18 knots/ janesville, WI airport was reporting 270 @ 14 knots gust 18 knots. [privacy data omitted] Chose runway 30 at C77 (Poplar Grove). Local winds based on tetrahedron were approximately 270…Accident 20090510007199APiper PA28180 · Globe, AZ(-23) Pilot reported that he made a normal approach to landing to runway 27 at the Globe, AZ airport. Pilot stated that the AWOS-3 weather he received reported an 8 knot direct crosswind. On short final, the pilot believes that the wind gusted and he was…Incident 20090510006559IBbavia 7GCBC · Angel Fire, NM(-23) On may 10, 2009 t 1515 MST, N356JB, an American champion, registered to the pilot made an off runway landing at angle Fire, NM after a gust of wind caused the aircraft to leave the ground prematurely during the takeoff roll on runway 17. Visual…Incident 20090510005689IHendri COMPAIRCA7 · Provo, UT(-23) Upon landing, with 6 knot crosswind and tail wheel down, the pilot pulled the thrust lever into maximum beta. As beta kicked in, the aircraft abruptly turned right. The thrust lever was immediately moved out of beta while simultaneously applying maximum…Incident 20090509047129IPiper PA-23-160 · Hollywood, FLAircraft landed on rwy 9R with landing gear partially extended. Left main gear had become down and locked, but nose gear and right main did not have time to fully extend prior to touchdown. Aircraft landed on right wing and nose landing gear doors. Both…Incident 20090509046989IPiper PA-11 · Valdez, AKWhile participating in the short take-off/landing competition at the Valdez airshow, the pilot "got on the brakes a little too hard" and nosed the aircraft over on landing.Incident 20090509046979IPiper J3C-65 · Valdez, AKDuring short field take-off/landing competition prop strike.Accident 20090509019959AAmtr KITFOXIV1200 · Madison, MSOn Saturday 09,2009 approximately 1600 local time N248DR were attempting to takeoff in a tandem formation from the Madison, MS airport (kmbo) on rwy 17. During takeoff the first aircraft briefly aborted takeoff when the second aircraft was near takeoff speed…Incident 20090509010259IDiamon DA40 · Montgomery, NY(-23) The PIC was instructing [privacy data omitted] flying from the left seat and [privacy data omitted] in the rear seat. This was the first time the student had flown with the instructor. Instructor had a total of 4.5 hours dual given at time of accident.…Accident 20090509009259ABbavia 7AC · San Diego, CA(-23) PIC was executing a touch and go to runway 27L at Brown field airport, San Diego, CA in a tailwheel Aeronca champ. On touchdown, with a crosswind, aircraft veered left, then right, running off edge of runway into dirt area and stopping upright.Incident 20090509007339IBeech 95B55 · Springfield, MO(-23) After purchasing the aircraft, [privacy data omitted] was delivering N558CB back to his home from long beach, CA to south riding, VA. During the third left of his trip, and IFR flight from tulsa, ok to louisville, KY, while in cruise at 11,000 feet MSL,…Accident 20090509007219AAmtr Bakengduce · Ramona, CA(-23) Pilot and passenger (also a pilot: commerical, instrument, CFI) departed Ramona airport, CA (krnm) at approximately 1400 PDT for a local pleasure flight. The plane was observed by several witnesses near the crash site,maneuvering at estimated altitudes…