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 20120124000679ANemesis · Camarillo, CAPilot made off-airport landing due to failure of engine to produce sufficient power to maintain flight. A/c destroyed during impact with raspberry field 'hoop houses'.Incident 20120124000579ICessna T210L · Sweetbay Natura, FLAircraft was heading northwesterly at 1400 feet in the left downwind pattern preparing for landing at F45, north Palm Beach county airport. The aircraft was abreast of the runway numbers when the engine sputtered and died. The pilot performed an emergency…Accident 20120124000469ABeech 58 · Green Pond, SCPilot landed at a private airport called pon pon and the location is at Green Pond, SC at bear island wildlife management area, the nearest street address is [privacy data omitted]. The coordinates at the accident scene are n 32'39.681 and W080'25.459 and the…Incident 20120124000349IPiper PA-34-200T · Henderson, NVOn January 24, 2012 1615 local, (0015Z), N8131B called in-bound declaring an emergency for an unsafe gear indication. Aircraft conducted a low approach and performed two touch and goes landings attempting to jar nose gear down to no avail. The aircraft landed…Incident 20120123001369ICostruzioni Aeronautiche Tecna P2008 · Port Orange, FLThe acft touched down hard in grass just short of rwy 23 during ldg, and the nose gear collapsed as the acft rolled onto the rwy. The acft then skidded and veered to the left before coming to rest near the left side of the rwy just before the displaced rwy…Incident 20120123001019IEmbraer EMB-145LR · Baltimore, MDOn jan 23, 2012 express jet flight 6060, on approach to international airport dulles (kiad), experienced a left main gear unsafe light indication. The crew diverted to Baltimore Washington international (bwi ) due to lowering RVR reports, and proceeded to…Accident 20120123000839ACessna 207A · Nikiski, AKOn January 23, 2012 about 0815 Alaska standard time, (ast), a tricycle wheel equipped Cessna 207A airplane, N800DF, sustained substantial damage while attempting to land on runway 36 at Mcgahan Industrial Airpark (AK73) at approximately thirty minutes before…Accident 20120122002549ACessna 150G · Quincy, FLOn January 22,2012 at approximately 1950 eastern standard time, a registered aircraft, N73JK Cessna 150G, serial number 15064948, crashed shortly after takeoff from Quincy municipal airport (2J9) Quincy, Florida . The certificated pilot was fatally injured on…Incident 20120122001919IBellanca 17-30A · Leonardtown, MDThe aircraft [privacy data omitted], a certificated airman, while deployed overseas for the military, instructed his non-certificated wife to enlist the help from the airport staff to run the aircraft's engine. [privacy data omitted] Was concerned with the…Accident 20120122001129ACessna 177 · North Vernon, INThe non-instrument rated pilot was conducting a flight from lake in the hills airport (3CK) to the madison, Indiana airport (ims). The flight was VFR on top and received flight following from ATC. The last radio contact occured approximately 15 NM north of…Incident 20120122000909ICessna 421B · Camarillo, CAAfter takeoff rotation, the forward left cargo door opened. The aircraft yawed to the right and began to slow. At this point the landing gear was already selected to the up poistion. The pilot decided to land strairght ahead. The pilot reduced power, lowered…Accident 20120122000489ABell 206B · Irving, TXThe pilot took off in this aircraft from kdto (denton airport) with 75 gallons of fuel. He picked up three passengers at dal, landmark aviation. He took these passengers to their destination in waco. He waited approximately one hour and they departed for the…Incident 20120122000439IPiper PA-12 · Clearwater, FLOn January 22, 2012 a Piper 12, N7972H, registered to [privacy data omitted], ground looped after landing while on a personal flight at st. Petersburg Clearwater airport (pie). Visual meteorological conditions prevailed at the time and a VFR flight plan was…Accident 20120122000279ACessna 172M · Richland, WAThe student pilot was performing touch-and-goes on runway 1 and had successfully completed two touch-and-goes prior to the accident. During the last landing, the aircraft landed flat and began to wheelbarrow/porpoise during the roll-out. The pilot was unable…Accident 20120121002419ABell OH-58A · Brawley, CAAero falcon OH-58 had a rotor mast failure just pior to lift -off of the aircraft, failure was internal of the main rotor transmission no damage to aircraft noted.Accident 20120121001699ARobinson Helicopter R44 II · Anchorage, AKHelicopter arrived at a landing zone planning to conduct part 133 external load cargo operations. The pilot landed the helicopter and commenced shutdown procedures with the helicopter in the low RPM flight idle position for cool down. During the cool down…Incident 20120121001539ICessna 172RG · Davenport, IADuring a preflight, the airman noticed that the battery voltage was low, and he decided to hand prop the aircraft to let the battery charge. This occurred late at night, as he wanted to leave early the next morning and wanted the battery fully charged. The…Incident 20120121001359IGates Learjet 35A · Ketchikan, AKDescription of incident: landed normally, after touchdown extended spoilers, actuated reverse thrusts and applied brakes. Aircraft started sliding and drifted left of center line until left main gear struck chunk of hard snow approximately 18 to 24 inches in…Incident 20120121000719IZing Aerosports ZA-PIG-90 · Carefree, AZDuring a balloon static display event when the balloon was being inflated, shortly after the operator switched from the blower to the burner, a gust of wind came up and pushed the balloon causing one of the tether line anchor eye bolts to break. The balloon…Incident 20120121000699IBeech F33A · Goodyear, AZFlight instructor [privacy data omitted] was providing instruction to student pilot [privacy data omitted]. During departure takeoff roll [privacy data omitted] popped the door open simulating a rejected take off. [privacy data omitted] Over reacted and…Incident 20120121000239INanchang China CJ-6A · Glendale, AZAirman was participating in the "young eagles" program, donating airplane rides in his CJ-6. Airman advises that he counsels his passengers about how to operate the brakes and also not to touch the red switch, located on the control stick. After engine start,…Accident 20120120001119AAero Vodochody L39C · Rainbow City, ALThe pilot received his IFR clearance from birmingham approach and was released for departure. This was a night IMC departure. The weather was 300 overcast and 1 mile. The pilot departed runway 24 less than two minutes after receiving his clearance. A witness…Incident 20120120000989IPiper PA-34-200T · Fort Stockton, TXOn January 21, 2012 at approximately 2000 local time, N47864, a PA-34, approached the Fort Stockton airport (fst) and attempted to extend the landing gear. The landing gear failed to extend. The pilot attempted to an emergency extention without success. The…Incident 20120120000569IMooney M20J · Edenton, NCN5608Y was on a local VFR flight from Northeastern Regional Airport, Edenton, NC (kede) taking off at approximately 15:35 EST. Shortly after 16:00 EST, the pilot turned toward the airport for landing and announced his position on CTAF 123.0 as "over the…Accident 20120119001929ARobinson Helicopter R44 II · Franklin, LAPilot was flying aircraft at a slow airspeed and low altitude in a left turn, hit a tree with the main rotor blades and crashed. There was a post crash fire that completely destroyed the helicopter.Incident 20120119001909IBeech 76 · Tulsa, OKOn January 19, 2012 in Tulsa Oklahoma's r.l. Jones airport (rvs) [privacy data omitted], pilot certificate no. [privacy data omitted] Took delivery of aircraft N6045M, a Beech-76 aircraft with serial number ME-184. The aircraft was being leased to air venture…Incident 20120119001219IPiper PA-30 · Lancaster, PAPilot could not lower gear. Requested tower personnel contact someone familiar with emergency operation of gear. Ground personnel assisted pilot with emergency gear procedures via telephone/radio. Gear collapsed upon touchdown.Accident 20120119000629AM-Squared Breese 2 · Bayou La Batre, ALStudent pilot was on his first solo. He had already completed one takeoff and one landing uneventfully. Prior to solo he had completed three touch and go's with instructor. Student pilot began his second solo takeoff and immediately after rotation the plane…Accident 20120119000619ACessna 172I · Springfield, TNDescription: aircraft was on the second leg of a cross country flight. The accident happened between dnv and jwn along a fifteen mile final in day VMC. Aircraft was found to have significant amounts of fuel leaking from the tank vents that had to be removed…Incident 20120119000429ICessna 152 · Big Bend, WIOn 01/19/2012 at approxametly 2051 z,(1451 LCL) a Cessna 152, N4723B, operated by spring city aviation of waukesha, Wisconsin and flown by commercial pilot, [privacy data omitted], experienced a loss of power while returning to waukesha at 2,100 feet MSL.…Incident 20120119000359IEmbraer EMB-135KL · Los Angeles, CAOn takeoff roll in sacramento on 19 jan, 2012, American eagle flight 3015 smf-lax, an Embraer 135KL, registration # N848AE, had the left inboard (number 2) tire tread separate from the tire casing. The flight crew did not report any issues with the takeoff…Incident 20120118001949IRockwell International 690B · Vidalia, GAAircraft fueled by landmark aviation in norfolk, VA. Began flight with 2375 lbs. Fuel. Hour into flight fuel read 1200 lbs. Counter indicated 600 lbs used. PIC believed it to be an indication problem. Fuel light illuminated with 400 lbs indicated. PIC began…Incident 20120118000229IPiper PA-28-181 · Phoenix, AZAircraft ran off the edge of taxi way. Written statement and interview of student pilot indicates that after landing on runway 7L, student attempted to exit runway with to much speed. Excessive speed lead to aircraft not making turn onto taxi way B9 which…Incident 20120117002349ICessna 177A · Berryton, KSAt approximately one hour into a routine pipeline patrol flight, while flying at low altitude, the pilot noticed a decrease in oil pressure. The engine began to run rough, and the pilot began to execute a 180 degree turn in an attempt to reach a nearby…Incident 20120117001789IPiper PA-28R-201 · Eastman, GADuring takeoff departure roll, herd of deer ran across runway, pilot attempted to miss the deer but was unable. Deer struck left front of aircraft, hitting propellor, left engine cowling and left wing root area. Aircraft has minor damage to engine cowling,…Incident 20120117001389ICessna A185F · Lime Village, AKAfter landing the aircraft was taxiing to the ramp and the aircraft gearbox structure for the left main gear appears to have failed. The fuselage and prop did not touch the ground. No sudden stoppage.Accident 20120117001309ACessna 340 · Salt Lake City, UTThere was fire damage in the right engine compartment. When the fire started is unknown. The exhaust cracked about 2-3 inches downstream from the turbocharger on the underside of the exhaust. The fire from the turbocharger caused damage to the firewall,…Incident 20120117000609IAero Commander 500-B · Eden Prairie, MNDuring climb from fcm the pilot noticed RPM drop for the left engine followed by other guages for the left side also dropping. Minneapolis approach was contacted and power loss was indicated. The left engine was feathered. The left engine was also shut down…Accident 20120116000979ASmith Aerostar 601P · Philadelphia, MSAircraft crashed during climbout.Accident 20120116000849ABoeing DHC-8-102 · Huntington, WVA piedmont flight 4117, in aircraft N839EX, struck a deicing truck boom with the left horizontal stabilizer, elevator and elevator trim tab, while taxiing on the hts ramp. The flight was an originator and the flight crew preflight identified frost on the…Incident 20120116000829IBeech 1900C · Anchorage, AKPIC requested use of taxiway mike from taxiway romeo for takeoff on runway 32. PIC followed centerline of taxiway mike at first then steered left followed by a right turn to align with runway (dog-leg) and gain additional runway length of about 100 feet. PIC…Incident 20120115001099IVelocity N22ud RUD Velocity XL-RG · Key West, FLPilot indicated that he put gear down and checked 4 times. Upon landing gear was in the up position. Later ops check revealed gear operated normally when reset button was pushed as emerg proceedures indicated.Accident 20120115000819AAgusta SW-4 · Fairbanks, AKOn January 15,2012 at approx. 1400 the crew of this SW-4 Agusta were conducting icing certification checks which involved hovering sideways while temporarily switching off the hydraulic boost. During the left sideways hover test, the helicopters cyclic…Accident 20120115000329APiper PA-24-180 · Brewster, MAOn 01/15/2011 N7648P departed martha's vineyard (mvy) at approximately 9:21 eastern standard time (EST). As evidenced by voice tapes and radar data the pilot was practicing approaches at hyannis (hya). A second pilot whom is a flight instructor, was on board.…Accident 20120115000319APiper PA-32RT-300 · Angel Fire, NMOn January 15, 2012 at 4:00 pm MST, N513CW, a Piper PA-32RT-300, crashed at the Angel Fire, NM airport during an aborted takeoff. The ATP rated pilot and his three passengers were uninjured. The airplane sustained substantial damage. The flight was being…Accident 20120114002389AEvektor-Aerotechnik Sportstar · San Diego, CAPilot stated he made a normal landing on rwy 26R. Experienced an uncontrollable left pulling sensation and was not able to correct. Lost directional control and ground looped on the rwy.Incident 20120114002359IPiper PA-28-180 · Winnemucca, NVOn January 14, 2012, at approximately 1300 PST, N8231W, Piper PA-28-180, was operated by student pilot [privacy data omitted], FAA certificate number [privacy data omitted]. The pilot was flying on a solo cross country flight from reno stead airport (rts),…Incident 20120114001159IPiper J5A · Groveland, FLOn January 14 2012, at 0745 EDT, a Piper J5-A cub, N38130, registered to [privacy data omitted] and piloted by the registered owner groundlooped after an emergency landing in a cow pasture due power loss of engine. Visual meteorological conditions prevailed…Incident 20120114000339ICessna 172RG · Seattle, WAOn January 14, 2012, [privacy data omitted], commercial student was practicing takeoff and landing with pilot instructor [privacy data omitted] at Boeing field onboard a Cessna-172RG, N6141R. Training began at 1330 local, after completing three takeoffs and…Incident 20120114000179ISchweizer 269C-1 · St. Cloud, FLDuring normal cruise pilot noted powerplant vibrations, followed by a low RPM warning light and horn, pilot proceeded to set up for autorotation and at that time the vibration stopped and engine quit. Autorotation accomplished into field with 10 to 15 ft tall…