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 20110831021809IEmbraer EMB-120FC · Anchorage, AKPtrs # 201105603NTSB# anc 11 na 090JAMMED aileron at top of climb. Complied with qrh procedure, declared emergency and landing was uneventful. Maintenance inspected the aileron system thoroughly in accordance with the EMB-120 fault isolation manual. Found the…Accident 20110831021619ACessna 172N · Plymouth, MADuring final approach, the aircraft landed hard on the main gears, bounced back up in the air and came down again very hard on the nose gear resulting in substantial damage to the aircraft nose gear, firewall, and fuselage floor. In addition, there was a prop…Incident 20110831020859IBell 206B · Frost Proof, FLWhile in flight, pilot experienced severe vibration, emergency descent and landing in an open field without injuries. Tail rotor gearbox was partially held on by one of four bolts. It was found that (1) tail rotor blade counter weight located inside the end…Incident 20110831020369IPiper PA-28R-200 · Livermore, CAFollowing a series of touch and go maneuvers at byron airport, student and instructor heard a strange sound and observed a small metal protrusion through the upper wing skin. Flight instructor and student observed that left main landing gear green…Incident 20110831019559IPiper PA-44-180 · Akron, OHWhile doing touch and go's at akr, on the third one PIC inadvertantly put up the gear and aircraft was not ready to fly. [privacy data omitted] Saw what was transpiring and put the gear handle in the down posistion but it was to no avail. Aircraft's left main…Accident 20110831019479APiper PA-28-181 · Provincetown, MAN6249C, Piper, PA-28-181, archer ii, departed runway 25 at Provincetown (pvd) airport on Wednesday 08/31/2011 at approximately 22:35 EDT and crashed 300 feet off to the left of runway 25. The a/c was observed in a left turn (by the us coast guard helicopter)…Accident 20110831018439APiper L-21B · East Liverpool, OHAs airman initiated a three point landing on runway 25, airman lost control upon landing and exited the runway to the south.Accident 20110830022459ARobinson Helicopter R22 Beta · Dutch Harbor, AKAccording to the airman, he took off from Dutch Harbor Airport to fly back to the bering pacific ranch his employer and owenr of the aircraft. One hour into the flight at approx 300' the engine began sputtering and quit. The airman auto-rotated down but…Incident 20110830022039IDiamond Aircraft Ind DA 20-C1 · Beaver Falls, PA08/30/2011 A student pilot enrolled in the professional pilot program at the community college of Beaver county, Beaver Falls, PA was flying aircraft N629DC operated by aviation certification and education solution inc (aces), a CFR part 141 pilot school. The…Incident 20110830021279ILandauer Meyer Little Toot · Belen, NMOn August 30, 2011 at 1110 MDT, N57CL, a homebuilt Meyer Little Toot, sustained minor damage when the airplane ground looped during landing roll out at Belen alexander airport, Belen, new Mexico. Visual meteorological conditions prevailed and a VFR flight…Accident 20110830020279AChristen Industries A-1 · Butte City, CAAircraft was observed conducting touch and go landings when a wingtip struck the the ground, the aircraft cartwheeled and caught fire.Incident 20110830019989ICessna 172G · Brookshire, TXWhile conducting a instructional training flight, the aircraft lost power due to engine failure. Instructor pilot made an emergency off-field landing in cow pasture. Investigation revealed a failure of the number 4 cylinder piston and connecting rod for…Accident 20110830019849ACessna 175 · Sugar Creek, OHAircraft was about 2400' MSL setting up to enter the pattern at kphd. The engine started to shutter then quit, propeller windmilling. Pilot found a field to land in and tried to restart the engine. Aircraft touchdown just above stall speed and struck corn…Accident 20110830019529ACessna TU206F · Bremerton, WA8/31/11 - During a telephone conversation with the pilot, he reported that prior to the accident flight, he verified that he had about 80 gallons of fuel on board the airplane, which equated to about 4 hours of fuel. The pilot said he departed helena at 1900…Incident 20110830018989IWeatherly 620B · Ontario, ORLost control on landing rolloutAccident 20110829022859ACessna 172M · Santa Monica, CAAirman made a normal takeoff from Santa Monica Airport (smo) and rotated at normal speed. Five to seven seconds later suddenly the aircraft airspeed indicator displayed high airspeed on the indicator (momentarily) and then failed and went to (and remained) at…Incident 20110829021399IBurnett George CH-II · Metropolis, ILPilot departed from runway 36 at the metropolos airport (M30). While climbing at approximately 400 feet AGL, the engine stuttered and then quit running. The pilot attempted to turn back to the airport and wound up short of the runway. While landing in the…Incident 20110829020559IBoeing 717-200 · Orlando, FLOn aug 29, 2011 at 10:55AM flight trs 491 (717-200, N975AT) was struck by a bird during a 5 mile final approach to runway 17L at Orlando International Airport (mco). The bird struck the upper leading edge of the vertical stabilizer. There were no injuries and…Incident 20110829020289IEmbraer EMB-145XR · Moline, ILOn 8/29/2011 at 12:37PM an Embraer 145 expressjet N27152, touched down on runway 10 at the Moline airport (mli). As the nose gear touched down the aircraft went into a gradual,uncommanded turn to the left which then increased rapidly. The aircraft departed…Accident 20110829020209AEnstrom F-28F · Menominee, MIAccording to the pilot, the purpose of the company test flight was to measure collective stick forces with the collective bias disabled. The pilot, who was the helicopter's only occupant, lifted the helicopter into a hover and then hovered clear of any…Accident 20110829020079AGrumman Acft ENG Cor-Schweizer G-164A · Monette, AROn August 29, 2011, at 1655 CDT, a Grumman G-164A, N48378, registered totri-air LLC, lost engine power and performed emergency landing in cotton field after takeoff, at Monette, Arkansas, while on an aerial application flight. Visual meteorological conditions…Incident 20110829019979IDalbec Edward D Lancair 320 · Leesville, LAPilot approached Leesville, LA (L39), and observed only one green gear light, the right main. Cycled gear and observed no green lights. Diverted to Fort Polk (kpoe) and observed three green lights. Tower personnel confirmed three gear down. On touchdown,…Accident 20110829019779AVans RV-12 · Windom, MNAt 0930 on 8/29/2011, when airborne and climbing [privacy data omitted] noticed air coming into cockpit, because he forgot to latch canopy. While trying to secure latch for canopy he noticed that the aircraft was descending toward the runway. [privacy data…Accident 20110829019049APiper PA-18-150 · Cordova, AKOn August 29, 2011 at approximately 1600 hrs. Local time a Piper model PA-18 aircraft sustained substantial damage following a complete loss of engine power during take-off initial climb. The commercial rated pilot and passenger were not injured in the…Accident 20110829019039AMaule M-6-235 · Hailey, IDGusty wind conditions prevailed at the time of landing, with three different reporting points on the field indicating wind directions varying as much as 100 degrees, with gusts exceeding 20KTS at times. Previous landing aircraft reported a -10KTS windshear at…Accident 20110829019029ACessna 172F · Atlanta, IDPrivate pilot attempted to land at 55H, a high density altitude airport, recommended for experienced mountain pilots and high performance aircraft, with a notation : no go-around. Pilot attempted to go-around after realizing he would not be able to land on…Incident 20110829017799ICessna 402C · San Juan, PROn August 29, 2011, federal aviation administration (FAA) south Florida flight standards district office (FSDO) san facility aviation safety inspector (ASI) joaquin puntonet was conducting an "r" item enroute inspection on air sunshine flight #412. The flight…Accident 20110828027239ATaylorcraft BC12-D · Point, TXPilot was returning to his private grass strip from a 1.5 hour recreational flight. He was in a midfield crosswind to downwind position at 150' AGL when the engine lost power. He was unable to make the runway and put the aircraft down in the field the grass…Incident 20110828023529IAeronca 7AC · Spearfish, SDPilot was practicing touch and go landings. On the third landing, aircraft veered left and could not be corrected. Pilot could not keep airplane on runway. The right wingtip struck the ground and received minor damage. The tail wheel was bent as a result of…Accident 20110828021389ACessna 172M · Plymouth, MIThe pilot stated that he departed tvc @ approx, 1930L on 8/28 and arrived at 1D2 approx. 2130L, landing rnwy 36. The pilot stated moments from touchdown, a gust of wind caught him and blew the aircraft to the west. He tried to stabilize and added power in an…Accident 20110828020389ASchweizer SGS 2-32 · Warner Springs, CAPilot released from tow and set up for a turn around hot Springs mountain ranger station. During the turn to a northerly heading pilot allegedly encountered sink/shear and could not penetrate, no other options left, pilot prepared for the enevitable crash.…Accident 20110828020269ABeech A36 · Napa, CAAircraft N6052W departed south lake tahoe, CA (ktvl) with the intended destination of Napa, CA (kapc) on 8/28/2011. The departure was at approximately 12:00 pm. The flight en-route was uneventful. Upon approach to the Napa, CA airport (kapc), the aircraft was…Accident 20110828019649AWheeler Dean S Vans RV-6A · Albany, OROn August 28, 2011, about 1345 pacific daylight time, a Wheeler vans RV-6A, N642DW, experienced in-flight separation of a propeller blade during climb out from the Albany municipal airport, Albany, Oregon. Following departure of the blade all engine power was…Incident 20110828018959IBrandt Jerry Pulsar XP · Wampum, PAThis event occurred on an Unregistered private grass strip on a runway with a heading of 185 degrees. The pilot had no intent to fly the aircraft; however, during high speed taxing the aircraft became airborne. Subsequently, the aircraft impacted the ground…Accident 20110828018939ACessna 170A · Near Grangevill, IDPilot took off north and reported reaching 300 feet altitude and heard bang and aircraft yawed right and he lost control. Aircraft crashed at end of runway about 150 feet to the right of center line in trees. Aircraft burned after impact. Pilot was able to…Incident 20110828018669ICessna 172N · Underwood, NDPilot stated he was on a cross country flight from mandan ND to minot ND. About 30 minutes into the flight at cruising altitiude of 3800 feet MSL with power setting at 2400 RPM there was a loud bang followed by severe vibrations and ripping of the cowlling…Incident 20110827021189IBell 206B · Gulf Of Mexico, LAPilot departed an offshore platform with 2 passengers enroute to sabine, TX. Pilot stated that he had .9 hrs of fuel on board when he departed the platform. At approximately 25 miles from sabine, TX, the pilot stated the fuel gauge started to drop fast and…Incident 20110827021179ICessna 310P · Alcoa, TNPilot extended landing gear and noticed 3 green lights. Upon final approach, verified again 3 green lights; however, main gear lights were not illuminated. He cycled the gear and still did not get green lights on the mains. Called tower, notified them, and…Accident 20110827020299ASchweizer 269C-1 · Titusville, FLPilot was practicing solo flight training operations in preparation for his commercial pilot rotorcraft-helicopter rating. Such practice was being conducted within an off-airport location leased by bristow academy, which contained designated landing locations…Incident 20110827019949IBeech V35B · Oxford, MSPilot stated he landed hard on runway 27 in Oxford, Mississippi. Damaging the nose gear tire and breaking the lower part of the nose landing gear off causing the propeller blades to be damaged when the blades impacted the runway. No injuries.Accident 20110827019799ACessna 182C · Grand Marais, MNAt approximately 1350 on Saturday, August 27, 2011 aircraft N9011T departed devils track lake, MN heading se, winds were from the south to southeast. After lift off from the lake, aircraft climbed to 100 AGL and above the tree top level, was never able to…Incident 20110827019459IPiper J3C-65 · Beaver Springs, PAWhile on final for runway 07 aircraft encountered a severe downdraft causing the aircraft to land short of the runway in a beanfield causing minor damage to aircraft.Incident 20110827019209IDehavilland DHC-6 Twin Otter · Lake Elsinore, CATwo british military parachutists collided just before landing. Aircraft not involved.Incident 20110827019019IPiper PA-18-150 · Tok, AKPtrs#AL01201102955UPON takeoff from Tok, AK. Airport, the propeller lost 6 inches of one blade. Pilot made emergency landing on Alaska highway.Accident 20110827017919ACessna 140 · Kent, WAUpon landing at crest airpark, (S36), on runway 15, the aircraft flipped over on its back at approximately mid field. The aircraft came to rest partially off to the right side of the runway. The pilot and student pilot on board were not injured. The pilot…Accident 20110826028829AWoolston Glenn E Zenith 701 Stol · Waterport, NYAircraft engine stop runing. Fuel line from left wing was clogged and fuel could not reach the engine.Accident 20110826028399AEurocopter AS 350 B2 · Kearney, MOOn August 26, 2011, at approximately 1841 central daylight time (CDT) (2341Z), N352LN, an aerospatiale AS350B2, owned and operated by air methods corporation doing business as lifenet, crashed in mosby, Missouri, approximately 1 nautical mile northeast of…Accident 20110826026299ARobinson Helicopter R44 · Batesville, TXOn August 26, 2011, the pilot was attempting to takeoff from his helo trailer but forgot to unlatch the left latch that holds the helicopter down and secured during transporting. The helicopter went to the left and hit the ground substantially damaging the…Accident 20110826023579AWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot of N7070L, a Wsk Pzl Mielec, M-18 dromader departed runway 24 at Freeport Albertus (fep) airport at approximately 12:30 CDT on August 26, 2011 to peform agricultural applications in the leaf river, IL area. The aircraft crashed into a corn field…Accident 20110826022069APiper PA-44-180 · Gaithersburg, MDThis accident was not reported to this FSDO office. During an inspection of this flight school maintenance facility, this aircraft was discovered in the rear of the hangar with a damaged right wing. The right engine was gone from the right wing. As I started…