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 20070921021629ARobsin R22BETA · Bend, OR(-23) On 09/21/2007 @ 0900 PST, the pilot [privacy data omitted] was taking his CFI check ride in a Robinson R-22 beta, s/n: 2187, N2341J. The pilot [privacy data omitted] was operating at an approximate altitude of 4,800 MSL/5,100 density and the following…Incident 20070921021539ICamron N160 · Westport, MA(-23) Aero naught stated he launched his balloon with six passengers on board from the head of the Westport river around 0645. He further stated that the wind picked up from the north so he climbed to 1100 feet. As he was going across the field approaching…Accident 20070921021269APiper PA32260 · Seward, AK(-23) During an attempt to land on the established airstrip, the aircraft touched down and hit a washout which was about one foot wide and two feet deep. In speaking with the airman, he mentioned that he had landed there "many many" times before and was aware…Incident 20070921020999IPiagio P180 · Lincoln, NE(-23) N106SL, being operated as avantair flight 106, landed safely at Lincoln, NE with emergency crews standing by. The flight had reported to air traffic control that they had an unsafe gear indication. Maintenance replenished the hydraulic fluid, swung the…Accident 20070921020939ASocata TB20TRINIDAD · Beatty, NV(-23) On September 21, 2007, at approximately 1940 local time a Socata trinadad TB20 gt, registration number N203AB, serial number 2211 owned by the pilot [privacy data omitted] decided to land at the Beatty Airport due to deteriorating weather at the…Incident 20070921020719IMooney M20E · Los Banos, CA(-23) Aircraft departed E36, with an intermediate stop at ccr. Enroute to las at 7500 ft pilot experienced engine vibration with loss of power. Pilot was on flight following with norcal. The pilot asked for nearest airport and was diverted to lsn. Landing at…Incident 20070920826659IBeech D35 · Lawrence, KS(-23) Enroute from sln to mkc the pilot reported engine running rough. Tried to divert to lwc. At 8:30 am landed in field 4 miles nw of lwc. Nose gear collapsed during landing. Minor damage to aircraft, no injury to pilot, no passengers.Incident 20070920826279ICessna 172N · Verona, KY(-23) Deer ran across runway in front of landing aircraft. Pilot applied brakes hard and the propeller struck the runway and in doing so the nose gear collapsed. Minor damage and no injuries to pilot, the only occupant.Accident 20070920825289ACessna 182Q · Glenwood Sprin, CO(-23) On 09/20/07 at 1230 MDT a Cessna 182Q, N97996, crashed while attempting to land at Glenwood Springs, CO (gws). The aircraft piloted by [privacy data omitted] with 2 passengers on board landed long on runway 32 and continued until it ran off the end of…Accident 20070920825179ACessna 182P · Santa Rosa, NM(-23) On September 20, 2007 at about 1140 MDT, a Cessna 182, N8033M, registered to and operated by the pilot [privacy data omitted] was attempting to land at Santa Rosa airport in new Mexico. The instrument rated pilot was on a VFR flight plan and landing…Accident 20070920824569AStbros SC7SERIES3 · Mcgrath, AK(-23) Shortly after take off aircraft struck trees and crashed in the lake. R/h wing and strut cut through trees at the end of the airstrip.Incident 20070920824069ICessna 172L · Beaver Falls, PA(-23) Upon takeoff the aircraft engine stopped at approx. 200' AGL. The pilot performed a 90 degree left turn while declaring an emergency with the tower and landed on the blackhawk golf course.Accident 20070920022689AJustac Escapade · La Grande, OR(-23) Upon landing, aircraft veered to the left and then ground looped to the right. This caused the left main gear to collapse and the propeller and left wing tip to come into contact with the ground. The CFI was the PIC and was giving instruction to check…Accident 20070920022329ACessna 190 · Yulee, FL(-23) The pilot/owner reported that wind gusts caught the plane as it was rolling out, blowing the airplane to the right. When the right main ran off of the runway the ground was very soft, the wheel pressed into the ground causing the airplane to turn more…Accident 20070920021889AAmtr RV9A · Barton City, MI(-23) Pilot while taking his son for a ride in the RV9A he built, lost control due to possible turbulence after take off on private airstrip located at [privacy data omitted]. Pilot in coma and expected to remain in coma until at least mid October 2007.…Incident 20070920021449ISocata TB20TRINIDAD · Imperial, CA(-23) On September 20, 2007, N260TB, a Socata TB-20 aircraft attempted to land at Imperial County Airport, Imperial CA. Pilot reported he was unable to extend the nose landing gear. The aircraft landed runway 26 at 1230 PDT. No injuries to pilot or…Accident 20070920021359ACessna 340A · Schellville/So, CA(-23) [privacy data omitted] cftpa is a canadian registered Cessna 340, and the pilot was a canadian citizen and held a canadian certificate. The flight departed from boise, on a cross-country IFR flight to novato, CA. Due to weather, the aircraft landed at…Incident 20070920021169IBeech 76 · Watkins, CO(-23) During a training flight (commercial, multiengine) the right engine was shut down intentionally. A restart was attempted per the checklist with no success. The engine would not come out of feather. Single engine operation indicated performance was…Accident 20070919824219AOrtizg RV10 · Kennesaw, GA(-23) On September 19, 2007 a RV-10, N416EC flying from kryy to kdhn flying at 145 knots at 4500FT. Cruise, the pilot noticed that the passenger door was vibrating. The pilot reached for the door handle and the door came open an inch or two. The pilot kept a…Incident 20070919022119ICessna 172F · Church Hill, MD(-23) The pilot [privacy data omitted] experienced a rough running engine in cruise flight. While preparing for an emergency landing, the engine quit completely. The pilot [privacy data omitted] then made a successful off-airport landing in a farmer's field.…Accident 20070919021649AAmtr RAGTOP01 · Perris, CA(-23) Pilot was attempting to land an ultralight aircraft on runway. Witnesses reported seeing the aircraft coming in too fast. Evidence shows that the pilot was running out of runway to safely stop the aircraft. Pilot throttled up the aircraft in an attempt…Accident 20070919021599ABeech B90 · Chattanooga, TN(-23) On 09/19/2007, at 2015 hrs the pilot [privacy data omitted] operated aircraft N10TM, a Beechcraft B90 king air, with three passengers on board from birmingham, al en route to georgetown, KY. Pilot diverted to Chattanooga when he discovered the fuel…Incident 20070919019739IZinair CH2000 · Dubuque, IA(-23) Student pilot was performing a touch and go landing on runway 31. After touchdown, the aircraft rolled about 100 feet when it began to wobble and pull to the left. The pilot applied right rudder, the nose gear collapsed (nose wheel fork separated from…Accident 20070918831439APiper PA28180 · Bridgeport, CT(-23) Student pilot lost control after landing runway 11 at bdr. Veered off runway and impacted light and sign. [privacy data omitted]Incident 20070918823949IAmtr Seawind · Hollywood, FL(-23) On 09/18/2007, during landing at North Perry Airport Florida, the right main landing gear oleo strut failed. The aircraft was removed from the runway. Boomerang aviation corp repaired rt main landing gear iaw with Seawind construction manual. Received…Accident 20070918021669APiper PA28140 · Flagstaff, AZ(-23) The pilot [privacy data omitted] is a student pilot and stated that he was practicing a short field takeoff on runway 21 at Flagstaff airport. The first 1,000 feet of the runway approach end was under construction and 6,000 feet was remaining for…Accident 20070918021209APiper PA22150 · Cooper Landing, AK(-23) At the time of takeoff, the pilot stated that moderate/heavy winds prevailed. The aircraft became airborne from juneau lake and climbed to approximately 80 feet then began to sink back towards the tundra. The pilot stated that it felt as if they had…Incident 20070918021049IDoug DC982 · Boston, MA(-23) American airlines, DC-9-82, N410AA, nose #410, 09/18/07, at 23:03, was under tow to the American hangar at Boston, MA on taxiway "a" when the tow vehicle inadvertently shifted out of gear causing the tow bar to jackknife and separated from the aircraft.…Accident 20070917829889AAmtr SE5AREPLICA · Hendersonville, NC(-23) Pilot took off from johnson field (8NC9) which is next to Hendersonville airport (0A7). He stated his magneto and carb checks were normal. When he began climbing out, his RPM began fluctuating from 2600 to 2000, back to 2600. He climbed over the trees…Incident 20070917829659IBoeing 727* · Newark, NJ(-23) Aircraft taxied into parking under control of one marshaller with zero wing walkers and struck a parked fork lift with the underside of the left wing, puncturing a hole in a fuel access panel.Accident 20070917824329APiper PA30 · Harold, FL(-23) The pilot stated that the flight departed with between 60 and 65 gallons of fuel onboard for the estimated 1 hour 20 minute flight. The pilot estimated the fuel consumption for the flight would be between 26 and 28 gallons total. The flight departed…Accident 20070917823909AAirtrc AT802A · Big Bear, CA(-23) N91357, AT802A, operated by the us forest service, crashed in field west of airport due to engine loss at 171310PDT just after departing Big Bear, CA, airport, on a fire fighting mission. Substantial aircraft damage. The sole occupant was not injured.Incident 20070917021179ICessna 172RG · Cedar City, UT(-23) On Monday September 17th at approx. 20:00 MDT, a Cessna 172RG, N6272R, while attempting to land on runway 20, the propeller struck the ground and the aircraft sustained minor damage at Cedar City Regional Airport (cdc). The aircraft was being operated…Accident 20070917020859AAmtr Rootsherpa · Scappoose, OR(-23) The pilot [privacy data omitted] was in process possibly buying this experimental aircraft, sherpa by name, manufactured by [privacy data omitted] in 1993. A company employee and rated pilot of sherpa aircraft, [privacy data omitted] was in the back…Incident 20070916831559IBbavia 7ECA · Harvey, ND(-23) The pilot of this flight is a student pilot with an expired student pilot/medical certificate conducted a cross country flight for which he was not authorized by an appropriately rated flight instructor and for which he had not received instruction. The…Accident 20070916829609AN20577 · Moultonboro, NH(-23) The pilot [privacy data omitted] was taking off from runway 20, (3600' paved) at moultonborough, NH (5M3). Lift-off and initial climb were normal. At approximately 3/4 of the runway length, the engine started to sputter and lose power. The pilot elected…Incident 20070916022029ICessna 172RG · Denver, CO(-23) Instructor was conducting flight training with his student pursuant to a commercial pilot certificate in a complex airplane. Student had performed 10 touch and go landings. After landing and during the touch and go, the student retracted the landing…Accident 20070916021899AAmtr VANSRV6 · Salem, OH(-23) Aircraft lost power during flight and engine was overheating. Pilot attempted landing on grass runway. Aircraft veered to the right and landed on a closed runway and collided with a maintenance truck. Aircraft spun around and stopped.Accident 20070916021809ABbavia 7AC · Kent, OH(-23) Aircraft landed in a crosswind and drifted off the right side of the runway. Right hand gear went into a ditch, aircraft bounced up and landed hard causing damage to right gear and fuselage.Accident 20070916020919ACessna 177RG · Compton, CA(-23) The pilot [privacy data omitted] stated that he was caught by an unexpected gust of wind from the south and he lost control during his efforts to counteract the effect of the crosswind. According to a CFI rated witness interviewed the following day at…Accident 20070916020469ACamron O77 · Creston, IA(-23) The balloon hit the ground hard while attempting to land in a hayfield/pasture. The pilot was thrown out of the basket on impact and the passenger was able to pull the deflation cord. The passenger sustained a broken arm in the accident.Accident 20070916019439AUltmag M56C · Shreveport, LA(-23) The pilot made a hard landing. The pilot and crewmember were ejected from the basket. The pilot grabbed the vent line in an attempt to deflate the balloon. The pilot was lifted into the air outside of the basket. The pilot fell to the ground from…Accident 20070916018499AAmtr RV7A · Vernon, TX(-23) PIC landed midway down on a 5000 foot long runway with a tail wind and failed to control the aircraft at the end of the runway.Incident 20070915825749IMooney M20K · Topeka, KS(-23) At Topeka, KS (top) at 18:43 local time, N231JS was on landing roll. Approximately halfway down runway 18, it was observed that the landing gear on the aircraft collapsed. The aircraft received minor damage. Only the pilot was on board and no injuries…Accident 20070915824249ABeech C90 · Savannah, GA(-23) Enroute IFR from blairsville, GA to Savannah, GA N515KJ, a Beech-90 king air. The pilot [privacy data omitted] advised he started with 500 lbs fuel in each tank which he stated he felt was sufficient for the flight. On descent into ksav he was cleared…Accident 20070915023459ABlanca 1730A · Dallas, GA(-23) Departed kctj (west carrollton regional airport) VFR at 1415L accompanied by another aircraft enroute to kryy (mccollum-cobb county airport). About 10 minutes prior to landing at ryy, at about 5000' altitude, pilot started descent for landing. The…Incident 20070915023289IPiper PA24250 · Bishop, CA(-23) During an interview conducted on September 18, 2007, the pilot stated he had just washed the aircraft and then had performed touch and go landings. The first touch and go was uneventful. The pilot stated during the second touch and go that he purposely…Accident 20070915022559AAmtr Sportstar · Erie, CO(-23)Although witnesses statements vary, they departed runway 15 at eik, on a local instructional flight, climbed to a reasonable altitude then spiraled toward the ground. One witness stated it pitched straight up prior to the spin. The aircraft impacted the…Accident 20070915022219AMncoup 110 · Utopia, TX(-23) The pilot was doing low level aerobatics over a friend's property. When flying inverted at 200 feet AGL, the plane dove into the ground and collided with trees. There was no post crash fire.Incident 20070915021529ICessna 421B · Pittsburgh, PA(-23) Aircraft landed on runway 32 after reporting a problem with the landing gear. ARFF responded and the aircaft taxied to the ramp without incident. Atlantic aviation maintenance work order #5615, dated 9-15-07, states that l/h down lock indication did not…