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 20090612047299ICessna 441During take off roll, at rotation from Dekalb-Peachtree Airport (kpdk) on the 06/12/2009 at approx 1626 local, aircraft experienced power failure of the right engine. Pilot shut down and feathered the right engine and elected to remain on the runway, he…Accident 20090612047239AMaule M-5-235C · Wasilla, AKThe pilot stated that on 06/12/2009, at 1130 adt, he departed finger lake (99Z) for a flight to the seward, AK area. He stated he departed the lake in a sw direction with gusty wind conditions. After a normal take off, at approximately 50 ft. he said the…Incident 20090612047229IColyaer SL Freedom · Boca Raton, FLAfter landing gear extension, there was no nose gear down indication. Pilot made a low approach down the runway, ATC tower (bct) advised him that the landing gear appeared normal. After touchdown on runway 5, the airplane veered to the left then exited the…Accident 20090612014309AAmtr Stallion · Marysville, CA(-23) Pilot stated that he landed then a gust of wind picked him up and he landed on the nose wheel and it collapsed hitting the prop. Aircraft came to rest on it's nose.Accident 20090612011819ABell 206B · Fort Worth, TXFlight instructor was conducting 180 autorotations when he tried to starch an autorotation landing hard and short on the grass end of the runway tail of the helicopter came in contact with the main rotor blades tail section was severed and aircraft slid down…Accident 20090612010649ACessna 175A · Polacca, AZ(-23) On June 12, 2009 at approximately 06:05MST the pilot performed an uneventful emergency off airport landing on Arizona state route 264 near Polacca, AZ due to loss of engine oil pressure. Subsequently the pilot serviced the engine with automotive oil and…Accident 20090612008619AAirtrc AT402A · Weona, AROn June 12, 2009 at approximately 1600 local an air tractor AT-402A, N50956, serial # 402A-1076 was fertilizing a field approximately 4 NM se or Weona, AR. After completing the second run of the application the aircraft turned north and encountered a tailwind…Accident 20090612008589AWermli KR2RANDROBIN · Anaconda, MT(-23) On the evening of June 12, 2009 at approximately 2030 local time, [privacy data omitted], an uncertified and untrained owner of N90804, a rand Robinson, KR2 homebuilt aircraft became airborne from runway 16 at Anaconda airport, Montana (3U3). The…Incident 20090612008459IPiper PA28236 · Rapid City, SD(-23) When returning from chadron NE, the pilot landed on runway 32 at Rapid City, SD. The aircraft landed on the centerline of the runway, and was gradually pulled to the left on rollout by a flat main left main tire. While exiting the runway on taxiway A4,…Accident 20090612007709ACessna 150 · Nampa, ID(-23) Pilot in command was operating the aircraft from the right set and lost directional control during landing runway 29 at Nampa Municipal because of a change in the wind conditions during the landing phase. Private pilot [privacy data omitted] was a…Accident 20090612007669AAviat A1A · Marfa, TX(-23)On June 12, 2009 at approximately 1655 CDT, N391C, an Aviat aircraft inc. husky model A-1A, was attempting to land at a private strip on the san jancinto ranch located about 50 miles south of Marfa, Texas. As the pilot decreased the power to idle and…Incident 20090611052839IBombardier CL-600-2B19 · Atlanta, GAOn Thursday June 11, 2009, at approximately 18:45, atlantic southeast airlines (asa) flight 5414, a Bombardier CL-600-2B19 registered as N857AS, made an emergency landing on runway 27R at Hartsfield airport in Atlanta Georgia (atl) with the left main landing…Accident 20090611025839ACessna 170B · Anchorage, AKStudent pilot [privacy data omitted] reported he and CFI [privacy data omitted] departed runway 25 @ appx. 5.45 am and flew to practice area on west side of cook inlet. Spent flight time in practice area performing basic flight maneuvers, returned to Merrill…Incident 20090611019559IUnivar 415C · Fairmont, MNCrankshaft sheared in descent and prop fell off. Aircraft landed with no damage and no injuries on runway 2 in Fairmont, MN (frm). Engine was still running upon landing. Crankshaft broke at front journal.Incident 20090611019169IAmtr PAZMANPL1 · Sioux Falls, SDWhile enroute from sturgis SD to Sioux center IA, the aircraft engine quit due to fuel starvation approximately 4 miles west of kfsd. The aircraft made an emergency landing at kfsd. The flight instructor onboard the aircraft at the incident, stated the…Accident 20090611014459ABlanca 1419 · Columbia, CA(-23) Pilot reported that on landing touchdown (runway 17 at O22) with a light wind from the right the aircraft was aligned with the center line and at proper speed when it veered violently left. He applied full right pedal and brake with his hand control and…Accident 20090611013439ARobsin R22BETA · Morristown, AZ(-23) On June 6, 2009, at approximately 1000 MST, N149SH, a Robinson R-22 helicopter, with [privacy data omitted] performing as pilot-in-command, collided with a power line while performing a low altitude flight near Morristown, Arizona. Witnesses reported…Incident 20090611012099IBell 206L1 · Gulf Of Mexico(-23) Crew change from MP265 to MP277, N518RL. Picked up at MP265 to a hover gauge checks 85% torque rotor RPM and turbine in the green. N1 91.5, tot 600 deg. I armed the floats and departed MP265. Midway into the flight pilot noticed the low RPM light and…Accident 20090611010779AAmtr Dragonflyii · Arthur, NE(-23) A non-instrument rated private pilot, on a VFR cross country flight was fatally injured after his dragonfly ii aircraft impacted terrain. Accident site was in marsh area approximately 20 miles east north east of Arthur, Nebraska. Data downloaded from…Accident 20090611010329AHiller UH12E · Stringtown, OKA mechanic at the repair facility the wreckage was taken to, advises he was told, that on the first load of the day the helicopter hopper tanks were loaded with herbicide and shortly after the lift off the helicopter began to settle. The pilot lowered the…Incident 20090611009889ICndair CL6002C10 · Portland, OR(-23) Aircraft landed at pdx and the right main gear suffered severe vibration. Aircraft was able to taxi to the gate and passengers deplaned normally. The shimmy damper on the rmg had come apart, which allowed the torque links to separate. The resulting…Incident 20090611009049IBeech 36BEECH · Dallas, TX(-23) Pilot was inbound to ADS, runway 15. Pilot reported on local control frequency stating a possible right side main gear flat tire. Alert 2 was called. Pilot executed low approach, runway 15, and tower personnel reported that tire appeared normal, but…Accident 20090610010509ABoeing 757222 · Denver, CO(-23) A torch like flame was seen coming from the right engine exhaust during engine start following push back. Ground personnel signaled to the crew to shut the engine down. The flame immediately extinguished when the crew selected fuel off. The aircraft was…Incident 20090610009649IAviat PITTSS2B · Granbury, TX(-23) On June 10, 2009 at approximately 2:00 pm, an Aviat pitts S-2B, N467PB, owned and operated by [privacy data omitted] ran off the left side of runway 18 and flipped over in a nearby creek after landing at Pecan Plantation Airport (OTX1) on a VFR flight…Incident 20090610008849IAmtr Challengerii · Clarion, PA(-23) The experimental aircraft builder was attempting high speed taxi tests with the aircraft. On the fifth attempt he inadvertently veered off the runway over an embankment. The nose landing gear and the right main landing gear was damaged due to the…Accident 20090610007739AAmtr CHALLENGER2 · Moses Lake, WA(-23) Flight intstructor was giving student pilot instruction to student pilot at Moses Lake Municipal Airport, WA (W20) and the student lost control of the aircraft. When the instructor took control of the aircraft he was unable to regain control of the…Accident 20090609047319AVans RV6-A · Gilbert, SCOn June 9, 2009 pilot [privacy data omitted] was attempting to land is Vans RV-6A aircraft on runway 27 at Whiteplains plantation airport, Gilbert, south carolina, identifier SC99. The pilot stated during his interview that he flew around the local airport of…Accident 20090609047199AHarden Bruc RV-7 · Elim, AKPilot was reported overdue for nome, Alaska on 6/09/2009. Aircraft found on 6/10/2009 on east bald mountain half mile from the village of Elim, Alaska. Aircraft was reported to be flying low. Weather in area was low fog at time of accident and the following…Incident 20090609014279IPiper PA39 · Decatur, TX(-23) This was an instrument currency flight so 2 pilots were the minimum flight crew required. Both pilots confirmed that the landing gear was down and locked before landing the aircraft. Upon landing on runway 17 at Decatur Municipal Airport the landing…Incident 20090609012209IBoeing 747400F · New York, NY(-23) Flight crew followed ATC taxi instructions. Twy "y" should not have been used for B-747 operations during this construction period.Incident 20090609010489IBeech C24R · Augusta, ME(-23) 06/09/09/ At approximately 10:00AM instructor bruce robbins was working with student wayne sherwood, on his commercial rating. The lesson for the day was reviewing 180 degree accuracy landings on runway 17 at aug. The student had done one normal landing…Accident 20090609010429ACessna 210K · Fredericksburg, TX(-23) Aircraft lost engine power on the downwind leg for runway 14. The instructor pilot conducted immediate action memory checklsit items and then turned towards the runway. Aircraft impacted 650 feet from the approach end of runway 14. The first impact was…Incident 20090609009459IJabiru J170SP · Walla Walla, WA(-23) This light-sport Jabiru was being flown by a student pilot on his first supervised solo. On the third landing, after all three wheels touched down, the aircraft veered to the right. The student pilot applied left rudder with no effect. This aircraft has…Accident 20090609009009AAgusta A109E · Santa Fe, NM(-23) On June 9, 2009 at 21:40 MST, an Agusta A109E, N606SP, registered to the new Mexico state police, rolled down a mountain during an emergency landing after a tail rotor strike while on a search and rescue flight. Instrument meteorological conditions…Accident 20090609007869AMosesc AEROLITE103(-23) On June 6, 2009, at about 0830 local time, N43598, a moses curtiss w. model aerolite 103 airplane was severely damaged when it collided with a cylindrical metal object between a house and it's out-building in los lunas,, new Mexico. As the small…Accident 20090608022119ACessna 172RG · Brownwood, TXOn June 8, 2009, at approximately 10:30 a.m. CDT, N6393R, a Cessna CE-172RG, was making a downwind approach runway 17 at Brownwood, Texas (kbwd), when the aircraft was hit by a buzzard that appeared suddenly in front and slightly left of the aircraft, causing…Incident 20090608017969IBeech C45H · Xenia, OH(-23) Pilot lost directional control of aircraft during take-off. Aircraft ground looped ended in a ditch which caused the left gear to collapse. Aircraft never became airborne.Incident 20090608015049ICessna 177B · Lihue, HI(-23) Lihue, HI: N7136X, C177, lifted off, immediately touched back down and went off the end of lih RWY21 due to an engine problem at 082356PDT. POB: one, injuries: none, damage: none 6/9 0656Z (hnl FSDO)Incident 20090608012039IAmtr SX300 · Ramona, CA(-23) On June 8, 2009 N38SX, an amateur built aircraft, model SX300, entered right traffic runway 27, Ramona Airport for landing. The pilot reported on base leg the nose gear was not indicating down and locked. He requested a low approach for visual…Incident 20090608010909IPiper PA31P · Lexington, KY(-23) Failure of the left brake on landing roll out on runway 22 at bluegrass airport (klex) affected the ground control of the aircraft by the pilots. The aircraft veered to the right of the runway hitting a runway light and left the runway surface. The…Accident 20090608008979ASorens Lightning · Brevard, NC(-23) According to witness statements, the owner of the aircraft and the flight instructor took off between 1330 and 1430 on June 8, 2009. Witnesses stated that the aircraft turned sharply left to right then was lost behind the trees. A loud noise was heard…Incident 20090608008719IPiper J3C65 · Los Lunas, NM(-23) On jun 8, 2009, at 1030 MDT, a Piper J3C-65, N92488, registered to [privacy data omitted](partnership), collided with a Cessna 320, N320CE, while taxiing at Mid Valley Airpark, Los Lunas, new Mexico, while on an personal flight. Visual metrological…Accident 20090608007849AMeyers OTW145 · Haskell, TX(-23) On June 08, 2009, at approximately 1355 CST, N34335, a Meyers OTW-145, ground looped and came to rest approximately 1700 feet on the east side of runway 18. This was a pleasure flight from halliburton field airport (duc) in duncan, Oklahoma to Haskell…Accident 20090608007679ATcraft BC12D · Somerville, NJ(-23) On landing rollout for runway 12, airplane began to veer to the right. Pilot attempted to correct but airplane did not respond. Aircraft ground looped off runway to the right, impacting a plastic storage container, then a Cessna cardinal, N34251, with…Accident 20090607047169ADehavilland Beaver DHC- · Anchorage, AKPilot attempted takeoff from Lake Hood Seaplane Base, Anchorage, AK (lhd) at 1333 adt, June 7, 2009 in a DHC-2 beaver on floats. There were three passengers in addition to the pilot on board. The weather was VFR with light winds. The takeoff channel was…Incident 20090607025239ILearjet 60 · Palm Beach, FLWhile enroute to fxe the flight crew heard a loud noise coming from the left side of the aircraft which lasted for ten minutes resulting in the low hydraulic pressure light to become illuminated. The PIC diverted to pbi and landed the aircraft. An inspection…Incident 20090607017499ICessna 421C · Teterboro, NJ(-23) On 06/07/09 [privacy data omitted] landed N251JL on rwy 24 at Teterboro Airport. He taxied off of the runway onto taxiway j, when his right main wheel went off the pavement into an area of the grass and mud. According to [privacy data omitted], his…Accident 20090607009669AAmrgen AA5B · Humbird, WI(-23) A gumman AA-5B "tiger" aircraft, registration N448DM, crashed in a wooded, rural area approximately 5.25 miles west of Humbird, WI, with two occupants onboard. The pilot held a private pilot certificate, was the registered owner of the aircraft, and was…Incident 20090607009239ICessna T210M · Houston, TX(-23) During approach to runway 6 at wiser airpark (eyq), the pilot neglected to extend the landing gear. The aircraft landed on its belly. Visual damage limited to the propeller, nose gear doors and belly of aircraft. No injuries.Incident 20090607007999IBbavia 7KCAB · Honolulu, HI(-23) On June 07, 2009, at 2212Z, N1840G landed on runway 4R at Honolulu International Airport. While exiting on to taxiway f, the aircraft right landing gear collapsed.