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 20070624011039ICessna 182L · San Carlos, CA(-23) Upon landing at sql, winds were from 230 @ 16 knots, gusting @ 22 knots. During touch down on rw 30 the left wing caught a gust of wind and the aircraft hit hard on right main, the nose pitched down hard and proceeded to go through one more pitch down…Accident 20070624010879APiper PA20 · Nenana, AK(-23) On June 24, 2006, N540A, a PA-20 ballanca, ground looped while landing on runway 22 at the Nenana airport. There was a 10-12 knot crosswind from the left. Aircraft veered to the right breaking the left main landing gear, striking the left wing on the…Incident 20070624010009IPiper PA34200T · Atlanta, GA(-23) On 06/23/2007 at 2326, acft N248FD, was involved in an incident during landing phase of flight at pdk airport. On touch down nose gear assembly collapsed, causing minor damage to aircraft. No injuries.Accident 20070624009829ACessna 170A · Bozeman, MT(-23) On Sunday June 24, 2007, a Cessna CE-170-A, N1316D, owned and operated by the pilot [privacy data omitted] stalled and fell into a coulee approximately 12 miles se of Bozeman/belgrade airport, bzn. The aircraft had departed livingston, MT, lvm, enroute…Incident 20070624009669ITlultr Stingsport · Tustin, CA(-23) Aircraft experienced loss of oil, then engine seized. Pilot made successful forced landing to closed Tustin marine base without further damage or injury.Incident 20070623825819IMaule M5180C · Battle Creek, MI(-23) Aircraft landed on the runway 23 at kbtl and ground-looped. It exited the runway approximately 1300 ft from the approach end and rolled into the grass. Winds were 10 gust to 15 from 150 and the runway was dry. The right wheel was broken and the right…Accident 20070623015119AAmtr RV6A · Laurel, MD(-23) Aircraft on first flight in 40 months. Pilot was making landing and stalled approximately 10-15 above runway. The nose dropped and hit the runway and folded back and the aircraft went over on its back. Pilot had minor injuries and was taken to the…Accident 20070623014579APiper PA28140 · Columbia, IL(-23) Mishap pilot experienced loss of engine power with student pilot while on a training flight earlier that morning. The fuel selector was moved to the other tank and engine power was restored. The aircraft was returned to H49 without any further event.…Incident 20070623013559IAmtr CH701SP · Lancaster, TX(-23) The pilot was conducting a pleasure flight around the klnc airport for familiarization with the aircraft. The first landing was stated by the pilot as hard. A second flight was subsequently made. The pilot stated that the approach for landing required…Accident 20070623013399APiper PA24250 · Flagstaff, AR(-23) On June 23, 2007, at 1320 mountain standard time, a Piper pa 24-250, N7584P, lost engine power during cruise flight and force landed approximately 27 statute miles east of Flagstaff, Arizona. According to the pilot, he was intending to fly to holbrook…Incident 20070623012769IPiper PA31325 · Gaithersburg, MD(-23) Safety counselor at gai statement:Saturday, June 23 mid afternoon, I was sitting in the gai restaurant and observed a navajo (N300HF) landing at what seemed to me an excessive speed, long and not on a stable approach I.e. porpoising in the flair. It…Accident 20070623011789AAmtr PJ260 · Lehighton, PA(-23) Student pilot was demonstrating a PJ-260 sr aero sport aircraft (N85136) to a prospective buyer at the beltzville airport (14N) located in Lehighton, PA. The student pilot made the takeoff, and allowed the commercial pilot, who was not endorsed for…Incident 20070623011559IAviat A1B · Missoula, MT(-23) On June 23, 2007, at approximately 1230 hours MDT, an Aviat husky A-1B, N700KY, registered to western adventures seaplane, inc., landed at Missoula International Airport, without having extended the wheels resulting in no damage to the aircraft. Runway…Incident 20070623011179IAmtr Acrosportii · Rome, GA(-23) On 6/23/2007 at approximately 0900 local, incident aircraft departed richard b. russell regional (rmg) airport for local area flight. At approximately 0910 local, aircraft was in cruise configuration at 3000 feet when engine power was lost, pilot stated…Incident 20070623011009IAmtr Searey · Modoc, SC(-23) Upon landing at clarks hill lake near Modoc, SC a gust of wind caused the a/c right wing to lift and the left wing dropped causing the left wing float to strike the water causing a/c to skid sideways to a stop. The float separated from the left wing and…Accident 20070623010249ABbavia 7GCBC · Coats, NC(-23) Aircraft landed on a Private airstrip in harnet county (albert gregory field). After landing pilot turned around to taxi back for takeoff when right main gear struck a hole and aircraft right main gear collapsed and spun aircraft around damaging left…Incident 20070622825729ICubcft CC11100 · Clyde, MI(-23) Plane landed on grass strip and pilot applied brakes during landing rollout and pilot stated that the brakes locked up. Then aircraft started to nose over and he applied more power and pulled back on stick but prop struck ground causing aircraft to flip…Accident 20070622022319ABbavia 8GCBC · Orlando, FL(-23) On June 22, 2007, the pilot [privacy data omitted] was attempting a banner pick up on the south side of Sanford airport. After missing the banner pick up, witnesses said the aircraft went into a steep climb while executing a high banked turn to the left…Incident 20070622018699ICessna T310Q · Indianapolis, IN(-23) The aircraft was landed without the nose landing gear in the down and locked position due to the failure of mechanical linkage utilized in the retraction/extension system of the nose landing gear. The failure of the mechanical linkage was caused by the…Accident 20070622016049APiper PA30 · Highgate, VT(-23) Pilot in command departed the south albany new york airport (4BO) at approximately 09:10 am on June 22, 2007, enroute to the Franklin County State Airport (fso). At approximately 10:15 am the pilot in command stated that he began a straight in approach…Incident 20070622015359ICndair CL6002B19 · Rochester, NY(-23) On June 22, 2007, at 1400 pm EDT, a Bombardier CL-600-2B19, N27185, flight 7180, operated by mesa airlines landed on runway 04 at Rochester international airport after declaring an emergency due to an oil pressure problem with the left engine. The crew…Accident 20070622014859ABeech A36TC · Cannon Falls, MN(-23) The pilot [privacy data omitted] departed du page IL (dpa) on 06/22/07 @ approx. 1230 local time. Intended desination was lake ville MN (lvn). There was no flt plan filed. Pilot contacted raleigh flt service for weather, however due to problems with his…Incident 20070622014259ISwrngn SA226TC · Spokane, WA(-23) A/c landed, shut down #1, shut off power, and unloaded cargo from aft left cargo door. Upon restart of #1, main bus power battery cable 6" from battery contactor in right wing inbd of nacelle arced to the hot bleed air duct above it and the hydraulic…Accident 20070622014019ABeech A36 · Cullman, AL(-23) While at cruise altitude of 11,000 feet the pilot noticed the engine starting to run rough. Shortly thereafter smoke started to enter the cockpit. The pilot radioed ATC and received clearance to descend. Upon the emergency landing the pilot realized…Accident 20070622013769ACessna 175 · Stony River, AK(-23) On takeoff roll from an off airport gravel bar, the aircraft hit some willows causing it to pull to the left hitting some trees. Substantial damage to the left wing, fuselage, nose gear, propeller, and engine. Unable to contact PIC [privacy data…Incident 20070622012679IAmtr LANCAIR235 · Torrance, CA(-23) The pilot departed long beach enroute to Torrance and was instructed by Torrance ATCT to enter right base to runway 29 right and to expedite with best forward speed. The pilot lowered the gear handle and did not verify that the three green gear down…Accident 20070622012279AComwth REARWIND185 · Redlands, CA(-23) Shortly after taking off, and reaching 100 feet, the aircraft ceased to gain any more altitude (despite pilot's control inputs to climb) and started to descend. The aircraft crashed upright. No post crash fire.Accident 20070622011719APiper PA32301T · Santa Fe, NM(-23) The pilot [privacy data omitted] began an approach to ksaf runway 28 with winds reported to be from 330 @ 26, G45. He elected to abort the landing and divert to albuquerque, NM. At approximately 7300 feet MSL, the engine lost power. The engine quit and…Accident 20070622011689AAmtr Sportstar · Grand Prairie, TX(-23) On June 6, 2007, at 1622 hours CDT, an evektor-aerotechnek a.s., N676E, owned & operated by aviator air centers, inc. crashed during takeoff on a 14 CFR part 91 personal flight under VFR conditions. No flight plan was filed. The aircraft was…Accident 20070622011679AMooney M20C · Price, UT(-23) Aircraft impacted high tension power lines one mile north of Price, UT. During the night approach to runway 18. Aircraft was destroyed with two fatals.Accident 20070622010859ACessna 182 · Paris, ID(-23) The pilot [privacy data omitted] departed from the logan-cache airport (lgu) on 06/22/07 about 0700. During his pre-takeoff check, he noticed a slight shimmy in the nose gear. He flew from logan, ut to Bear lake, ID (1U7) arriving around 0730. During…Incident 20070621826319IWthrly 620B · Freeman, SD(-23) On June 21st at approximately 8:00 pm aircraft N9020W took off from a Private strip at Freeman, SD and struck a berm which broke one main landing gear wheel off. Aircraft made an emergency landing at yankton, SD and caused minor damage to the aircraft.Accident 20070621016789ACessna 182C · Taylorsville, NC(-23) On June 21, 2007, about 1201 pm, a Cessna 182, registration number N8691T, was destroyed when it impacted the ground at the Gryder-Teague Airport (NC58), near Taylorsville, north carolina. The certificated private pilot/owner and the certificated flight…Accident 20070621013329AAmtr Lynchhelicyc · Erie, CO(-23) The pilot [privacy data omitted] lifted off in his home built helicycle at approximately 1130 MDT. This was his first flight after spending 3 years building the craft. He made 2 circles, never getting more than 100 yards from his lift-off point. As he…Accident 20070621010969ACessna 152 · Miami, FL(-23) Cessna 152 had hard landing on runway 27R Kendall-Tamiami airport.Incident 20070620017429IMooney M20K · George Town Ex(-23) Pilot lowered landing gear and failed to notice that gear was not down and locked due to circuit breaker being popped. Pilot reported that he was fatigued at the time of the incident.Incident 20070620016989IPiper PA18150 · Perry Island, AK(-23) Aircraft was in cruise flight. Engine began to run rough. Pilot decided to land on beach as a precaution. Aircraft hit a depression and went airborne then came to rest in three feet of water. No damage to aircraft or pilot.Accident 20070620016779ACarson 47GC4 · Wall Township, NJ(-23) The pilot stated that he and a passenger departed kblm at approximately 1800 EDT on June 20, 2007 for the purpose of a pleasure flight. The aircraft flew a circular route to the south approximately 16 miles. On return approximately two miles from the…Accident 20070620014999ALuscom 8A · London, OH(-23) On June 20, 2007 at approximately 0930 hrs. Local time, during landing attempt at Madison County Airport (uyf), London Ohio, aircraft departed the right hand side of runway 27 impacting the taxiway sign. The pilot sustained a minor injury exiting the…Accident 20070620014719AAirtrc AT301 · Fergus Falls, MN(-23) While in cruise flight at approximately 1500 AGL, the aircraft started to vibrate violently. The propeller speed ring came off (aircraft area encasing the propeller). Then the left side door came open. The windshield became covered with pesticide fluid…Incident 20070620014409ISZD SZD45AOGAR · Baker, CA(-23) On June 20, 2007 pilot of N141AS initiated a VFR flight from skylark field (CA89) to jean airport (0L7) with fuel stop at apple valley airport (kapv) to deliver motorglider. Approximately 10AM local time pilot departd from skylark field (CA89) to apple…Accident 20070620012089AAyres S2RT15NORMAL · Stuttgart, AR(-23) On June 20, 2007, at approximately 1400 CST an Ayres corporation S2R-T15, N113CA, operated by custom air inc, as an aerial application aircraft, impacted a bean field while maneuvering near Stuttgart, Arkansas. The aircraft was piloted by [privacy data…Incident 20070620012059ICessna 402B · Boise, ID(-23) On June 20, 2007 while on a flight from boi to geg Cessna 402-B, N7947Q, s/n 402B-0397 experienced a complete avionics bus failure. This was due to a avionics master switch failure (p/n CM-3589-50). This aircraft turned around and landed at Boise by…Incident 20070620011989IBeech B36TC · Hudson, CO(-23) N6929B, a Beech bonanza, landed at platt valley (18V) on runway 33. The wind sock was straight down (calm). The pilot noticed a dust devil to the north. After refueling he dripped the tanks, did a complete checklist, and proceeded to the runway. The…Accident 20070620011629ABeech 1900D · Laramie, WY(-23) On June 20, 2007 Laramie (lar) WY a BE-1900-D aircraft, N253GL ran off the runway during the landing roll out. Great lakes airline flight 5174 departed worland (wrl) WY on a 14 CFR 121 scheduled flight at 1527 local enroute for lar. At approximately…Incident 20070620011589IEMB EMB135LR · Boston, MA(-23) Amr American eagle flight #4539, Emb-135-LR, N731BE, on approach to runway 22L at Boston, MA lowered the landing gear; however, the pilots were unaware that the landing gear did not come down. The aircraft touched down and skidded along the runway on…Incident 20070620010559IBeech D35 · Deland, FL(-23) On Wednesday 20 jun 2007 at approximately 1025 am, N2927V, a 1947 Beech BE-35D bonanza single-engine land airplane, made an unintentional gear-up landing on runway 12 at Deland-Taylor municipal airport, Deland, FL. The pilot in command was [privacy data…Accident 20070620010429ACessna TU206G · Baton Rouge, LA(-23) The pilot stated the engine quit while on right base for runway 4 right at Baton Rouge metro airport. The aircraft crashed into a residential area, no injuries. The pilot stated he switched the fuel selector from the left tank to the right tank after…Accident 20070620009979ACessna 185C · Las Vegas, NV(-23) On June 20, 2007, at 0930AM Cessna 185 operated by the Montana state dnrc as a public use aircraft, performed an emergency approach as a training maneuver to an uncontrolled grass strip with the intent of performing a go-around. When the pilot initiated…Accident 20070620009859ABell 206B · Sand Springs, OK(-23) A television station was filming a promoational segment involving the helicopter that was involved in the accident and a satellite communications vehicle (scv). The scv was parked on the south end of a taxiway that is west and parallel to a single…