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 20090714018009APiper PA28R180 · Tucson, AZ(-23) Interviewed [privacy data omitted]. The following was related during the interview, on the morning of 07/17/2009, [privacy data omitted] did a preflight of the aforementioned aircraft and no damage was noted. [privacy data omitted] Proceeded to fly the…Accident 20090714013519APiper PA46310P · Westley, CAOn July 14, 2009, N330HT a Piper PA-46-310P, with the owner and instructor pilot onboard conducting a biennial flight review. During this instruction and air work, the ip seated in the co-pilots position noted smoke coming from the floorboard area which…Accident 20090714013489AScwzer SGS126A · Anza, CA(-23) Flying northbound at 7000 ft, the glider descended rapidly due to loss of lift. The pilot made an forced landing in a dirty field 5 miles south of Anza, CA. The aircraft's right wingtip hit a fence post which caused substantial damage to the glider's…Accident 20090714011649ACessna U206G · Big Creek, ID(-23) During a flight conducted for the purpose of completing a flight review in accordance with 14 CFR 61.56, immediately after takeoff from the simonds airstrip, the aircraft impacted trees in the departure path and crashed. The aircraft was destroyed. No…Incident 20090714011369ILet BLANIKL13 · Crawford, CO(-23) While attempting to takeoff during an instructional glider flight aircraft veered off the runway, hiting a bush, and fence post. The pilot stated that he had lined up left of centerline to avoid a drop off on the left side of the runway. Pilot stated…Incident 20090714011009IPiper PA28RT201 · Tooele, UT(-23) Pilot was performing steep spiral manuevers in preparation for his commercial checkride while waiting for the traffic pattern to clear. Once the pattern was cleared pilot entered traffic pattern. Pilot stated that he heard the gear horn going off but…Accident 20090714010859ACessna 172S · Fort Worth, TX(-23) Student pilot departed kftw for solo flight in the local area. Aircraft fuel was exhausted after .5 hours of flight time. Aircraft landed in pasture after hitting cattle fence, becoming airborne then hitting a tree, then hitting the bank of a man-made…Incident 20090714009689IAmtr RV4 · Friday Harbor, WA(-23) On July 14, 2009, N84RM being flown by [privacy data omitted] an airline transport rated pilot, sustained minor damage, when the pilot applied heavy braking and the nose of the aircraft struck the runway.Accident 20090713047679ABeech G18S · Yakutat, AKOn July 13, 2009, at approxiamtely 2248 UTC, N93CA a Beechcraft BE-18 operated by coastal air, LLC (5CLA), [privacy data omitted] pilot-in-command, landed at the Yakutat muncipal airport (paya) on runway 29. During the landing rollout and approximately at the…Accident 20090713024309ABoeing 7373H4 · Charleston, WVCharleston airport, WV (crw): southwest airlines flight 2294, a B737, enroute from nashville, TN (bna) to baltimore, MD (bwi) diverted and landed on runway 5 due to a hole in the fuselage and a pressurization problem inbound. The ARFF responded and the…Incident 20090713017979IMooney M20K · Mount Sterling, IL(-23) The left magneto was found to fail only after warming up and the right magneto was found to have bronz metal shavings inside from the failure of the gear bearing. There was moisture found in both magnetos.Accident 20090713013479ARobsin R44 · Marysville, CA(-23) Pilot departed auburn airport at approximately 10 am enroute to nelson, CA. While enroute at 500 AGL, the pilot and his passengers decided to fly at a lower altitude to have a better look at the river bed over which they were flying. The pilot initiated…Accident 20090713012299ADiamon DA40 · Cape Girardeau, MO(-23) The aircraft, N544DS, was involved in a ground accident with a parked fuel truck on the evening of July 13, 2009. The pilot stated he was under the impression the maintenance work had been completed but did not verify the work on the aircraft's brakes…Incident 20090713011989ICessna 525A(-23) On July 10, 2009, at 1400 hours this aircraft departed philadelphia for jenks,ok (rvs). The aircraft made stops at louisville (sdf) and tulsa (tul), completeing the flight at 1630 local time, landing at rvs. The pilot indicated the flight was conducted…Accident 20090713011709ARobsin R22BETA · Bedford, MA(-23) The accident aircraft and crew were engaged in what was the students second instructional flight. After completing an uneventful portion of the flight which incluced upper air work such as straight and leel flight, turns and acceleration/deceleration…Accident 20090713011679ATcraft BC12D · Joplin, MO(-23) Taylorcraft N96660 was cleared to land on runway 18 at jln. The traffic controller observed the Taylorcraft making a very slow and low approach to runway 18. The controller also observed the aircraft make contact with the runway several times during the…Accident 20090712014849ARemos REMOSG3600 · Erie, CO(-23) On July 12, 2009 the instructor was instructing student pilot in N408RA, a Remos G-3, a light sport category airplane at Erie, colrado tri-county airport. The student made a rough landing and bounced into the air at which time the instructor ordered a…Accident 20090712014839APiper PA18 · Erie, CO(-23) On July 12, 2009 the instructor was instructing student pilot in N408RA, a remos G-3, a light sport category airplane at Erie, colrado tri-county airport. The student made a rough landing and bounced into the air at which time the instructor ordered a…Incident 20090712014349IAmtr Glasairiii · South El Monte, CA(-23) Pilot stated that he departed fullerton airport and at 2,000 ft above South El Monte, started having engine problems. Due to engine losing partial power, he was forced to land in a concrete drainage wash. There was minor damage to the aircraft and no…Incident 20090712014289IPiper PA32RT300T · San Jose, CA(-23) The pilot stated that upon take off from E16 (south country) he heard and felt a thump at his feet when he raised the gear. All the circuit breakers, gear lights, and master alarm appeared normal. The aircraft proceeded to krhv and on final he attempted…Accident 20090712011859APiper J3C65 · Porter, TX(-23) Pilot reported loss of power, try's to land on sand bar next san jacinto river, aircraft's right main landing gear caught electrical wire that crossed san jancinto river, causing aircraft to hit ground and snapping off one of the telephone poles…Incident 20090712011429IWilson SMITHDSA1 · Texarkana, AR(-23) On July 12, 2009, at 1553, a smith miniplane, N1131, registered to [privacy data omitted], impacted the runway after landing as a result of the left landing gear strut breaking at the Texarkana airport (txk) in Texarkana, Arkansas, while on a pleasure…Accident 20090712010369ASZD SZD59 · Durango, COThe pilot was on approach to land runway 17. When the pilot turned final he saw a tow plane with a glider taking-off runway 35. The pilot turned right to avoid the tow plane. He stated that he was going to turn around 360 degrees in a hard turn, to avoid the…Accident 20090712010339AAmtr SH2R · Sequim, WA(-23) Pilot stated that he was in a bit of a hurry to beat the sunset and had gotten flustered when a caravan taxi around him while he was performing his run-up. The pilot stated that he uses the header fuel tank during taxi and run-up and that it is on his…Accident 20090711054029AEmbraer-Emp ERJ 170-200 · Ind, INPassenger on republic airlines flight 3143, dca-Ind, July 11, 2009, suffered broken ankle. Passenger was out of seat on approach when aircraft experienced turbulence resulting in injury.Incident 20090711049199ICirrus Desi SR-22 · Calera, ALFirst attempted landing on runway 34 at the Shelby County Airport, AL (keet) hard landing; propeller strikes visibleon runway pavement; pilot attempted a go-around, 2nd attempt landing on runway 16 at (keet) with a tail wind; the aircraft floated 1/4 down the…Accident 20090711049169AAeronca 7AC · Auburn, METhe pilot had stated he was at 2800 feet and started to lose power. He switched the magnetos settings from both to left to right going back to both and did not seem to kame the airplane regain power. We were notified by the pilot they had already drained the…Accident 20090711025289ANoorduyn UC-64A · Akiachak, AKAircraft failed to maintain cruise altitude due to loss of engine power. Pilot attempted emergency landing at Akiachak Airport. Ground contact was made short of runway. Aircraft came to rest inverted.Incident 20090711019549IEMB EMB145LR · Covington, KYOn 7/11/2009 @ 1655Z, an Embraer 145LR aircraft departed cvg to phl. On the climb-out at FL 210, the pilot reported a possible lightning strike and requested a priority return to cvg. The pilot's windshield had been cracked (spiderwebbed), and the crew did…Accident 20090711014789ABarber Shaglasairrg · St Johns, FL(-23) The accident aircraft was in a two aircraft formation flight. The accident aircraft departed the formation in a descending spiral, impacting the ground at a high speed. I was contacted by FAA regional communication center during my duty at telephone…Accident 20090711013629AGulstm 680F · Angel Fire, NM(-23) Pilot applied takeoff power, released brakes and started takeoff roll on runway 35 at angle Fire, NM airport (axx). At bottom of white arc, pilot pulled yoke back to start rotation. Aircraft deviated to left, pilot applied right rudder to correct, but…Accident 20090711013299AUnivar 415C · Corona, CA(-23) Aircraft N87295, and engineering and research 415C, experienced a loss of power and collided with terrain near Corona, CA. The pilot received minor injuries and the aircraft suffered substantial damage.Accident 20090711011739ABell 206B · Burlington, WA(-23) After completing a 300 acre spray job at 5 locations. [privacy data omitted] Was positioning the helicopter on a trailer with a right cross wind of 5 m.p.h. the right skid of the helicopter hung-up on the trailer. The aircraft ended up on its right side…Incident 20090711011179IPiper PA23250 · Wilmington, DE(-23) Nose landing gear collapsed after landing during rollout. [privacy data omitted]Pilot is a member of the us coast guard auxiliary and was completing a coast guard mission at the time of the incident. The following quote is an excerpt from the pilot's…Accident 20090711010439APiper PA28235 · Rutherfordton, NC(-23)Received a call from the atl com center (1340 local) stating that he was going to patch me through to a [privacy data omitted] and there had been an accident at Rutherfordton, NC (fqd). [privacy data omitted] (CFI) stated that he had soloed his student,…Accident 20090711010349ACessna A188A · Elmwood, NE(-23) Pilot attempted takeoff from a private grass strip and struck standing corn at the departure end of runway 13 causing the aircraft to flip over and land inverted. The Cessna A188-B agtruck sustained substantial damage. The pilot received only minor…Accident 20090710857479ABeech 35-A33 · Las Vegas, NMOn July 10, 2009, at 10:15 MST, a Beechcraft 35-A33, N4334W,[privacy data omitted] made an off airport landing about 1 mile southwest of the Las Vegas, NM airport while on a part 91 flight. Visual meteorological conditions prevailed at the time and no flight…Incident 20090710047639ICessna U206D · Homer, AKOn July 10, 2009 at approximately 11:00 am, pilot [privacy data omitted], with 5 passengers on board landed on the "clamming beach" at chinitna bay. This beach is located on the north side of the bay, the second bay in from spring point. On roll out after…Incident 20090710047559IRobinson He R22 Beta · Pompano Beach, FLOn July 10, 2009, at approximately 1245 eastern standard time(EST), N122AK, a Robinson R-22 beta, serial number 2028 landed in an open area located at 2780 north powerline road, Pompano Beach, Florida, 33060. No damage to the helicopter was observed and…Incident 20090710020339IPiper PA44180 · Hillsboro, TXInstructor and student were on instructional flight. Shut down one engine for training purposes. Engine would not restart. Density altitude was high so instructor/pic decided to land at the Hillsboro airport. Inadvertantly, the landing gear was not extended…Incident 20090710019489IBeech A35 · Bloomington, INDuring a flight from columbus municipal airport (bak) to coles county memorial airport (mto) the Beechcraft A35 bonanza, registration number N8511A, serial number D-1933, experienced a partial electrical failure. The pilot contacted terre haute approach…Accident 20090710015079AScwzer G164B · Beaman, IA(-23) The pilot performed the normal before takeoff checks. He said the engine was running smooth, and both mags checked good then lined up on the center of the strip, heading to the north, and brought the power up to 35 inches of manifold pressure and 2300…Incident 20090710013129ICessna 310F · Port Aransas, TX(-23) Pilot reported he landed on runway 12 at the Mustang Beach Airport in Port Aransas with the landing gear extended. After touch down, and during the roll out the aircraft right main gear collapsed first: followed by the left main and nose gear. Pilot…Accident 20090710012889AAmtr Ctsw · Yellow Pine, ID(-23) Pilot did not maintain directional control during landing. The aircraft veered to the side of runway and hit a pile of rocks. Substantial damage to the properller, lower engine cowling, nose gear, lower fuselage and top of wing.Accident 20090710012589AAyres S2RT34 · Hertford, NC(-23) While on a flight to familiarize PIC with aircraft and to check calibration of spray nozzles with water, aircraft impacted with ground in cornfield. No witneses to the accident. Aircraft impacted ground inverted with no evidence of rotation or lateral…Accident 20090710012219AAmtr EDGE540 · Tarkio, MO(-23) The pilot, who was the sole occupant of the aircraft, took off at 14:18 hours CDT on a local VFR flight from runway 18 at Gould Peterson Municipal Airport (K57) in Tarkio, Missouri to practice her aerobatics routine. She performed vertical climb with…Accident 20090710011849AAirtrc AT502B · Reydell, AROn July 10, 2009, 1230 local, AT-502B, N60023, serial # 502B-315, was taking off from a private airstrip located approx 3 NM se of Reydell, AR to fertilize a local field. The aircraft departed with a heading of 5 degrees and was loaded with 2800 lbs of urea,…Accident 20090710011759ACessna 310J · Fort Worth, TX(-23) On July 10, 2009 at 18:30 a Cessna 310J, N3106L was taxing on to the active runway when his right main gear collapsed. The pilot was on a CFR part 91 return flight to tulsa Oklahoma. The airframe, engine and prop was all heavily damaged. However the…Accident 20090710010469AAmtr VANSRV4 · Wendover, UT(-23) Pilot stated that upon landing he felt like landing was gong to be bad. While attempting to correct the situation the pilot added full power causing increase of torque and lost control and the aircraft which proceeded to ground loop, striking the right…Incident 20090709014219ICessna 177 · Long Beach, CA(-23) The pilot stated that on final approach he noticed that his airspeed was approximately 10 knots slower than his usual approach speed with a slight weathervane tendency which he corrected for, however upon touchdown, the rollout was normal until the…