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 20120512007959APool H/Pool D Murphy Moose · Steamboat Sprin, COOn 05/12/2012 at approximately 12:15 hrs MDT, N223HD, an experimental amateur-built Murphy Moose aircraft sustained substantial damage while landing at Steamboat Springs, (ksbs) airport, CO. The pilot and the two passengers onboard sustained minor injuries.…Accident 20120512007869ACessna 182S · Arcola, TXAircraft with student pilot and flight instructor landed on centerline of runway 27 at approx 18:30 with everything being normal. On roll out aircraft stayed close to center line approx 250 yards and then began to veer to the right, going off the runway, r/h…Accident 20120512007849ARisher Jimmy E Vans Aircraft RV-8 · Pecos, TXOn the landing rollout after landing on runway 32, the aircraft experienced crosswinds which caused a ground loop. The left main landing gear bent and damaged the left fuselage, left wheel skirt, and left wing tip. The pilot, who was the sole occupant, was…Incident 20120512007449IPiper PA-24-250 · Osceola, IAPilot landed on runway 36 at Osceola (I75) and during roll out, noticed severe vibration. Once there was weight on the nose landing gear (nose wheel shimmy), the aircraft began to drift toward the left. Pilot could not correct for drift. Left main landing…Incident 20120512007269IPiper PA-28R-200 · Reading, PALanding gear collapsed on landing runway 31 at Reading Regional Airport.Accident 20120511010739ACessna 401 · Chanute, KSAircraft was on an IFR flight from tulsa riverside airport (rvs), to counsil bluffs, IA (cbf), and was in cruise flight at 10,000 feet near Chanute, KS. According to ATC, the pilot requested a lower altitude, was cleared to and descended to 8,000 feet. ATC…Accident 20120511008739AMaule MX-7-235 · Roche Harbor, WAOn 5/11/2012, at approximately 1435PDT, Maule MX-7-235 aircraft, N114MK, sustained substantial damage due to a runway excursion during landing at Roche Harbor, WA (WA09). The sole occupant, the pilot-in-command (PIC), was not injured. The PIC was conducting a…Incident 20120511008709ICirrus Design SR22 · Fishers, INDuring taxi after landing,the pilot attempted a left turn and could only turn right. The aircraft departed the runway surface onto the grass. The nose wheel was castered to the left, only allowing the aircraft to turn left.Accident 20120511008329AChampion 7GC · Rexburg, IDAfter a low power descent and adding in power, the oil pressure did not increase into the normal range. The pressure available began dropping further, so the pilot elected to make a precautionary landing. While landing, the aircraft struck a previously unseen…Incident 20120511007489IGulfstream American AA-5A · Millington, TNOn may 11, 2012, at approxmently 1300 local, N26961, a Grumman AA-5A, upon landing at Charles Baker airport, 2M8, on runway 18, bounced in the air and porpoised. The aircraft struck the runway, damaging the prop, folded the nose gear under the fuselage, and…Accident 20120511007399ABoeing A75N1(PT17) · Weirsdale, FLThe acft departed the left side of rwy 9 during landing, went over a downward-sloping embankment, and impacted a citrus tree before coming to rest nose-down. The acft sustained structural damage to the rt wings and rt horizontal stabilizer & elevator. The plt…Incident 20120511007289ICessna 172P · Prattsburg, NYOn Friday may 11, 2012 this office was notified by the eastern region comm center of an incident involving a Cessna 172 (N99941) landing in a corn field in Prattsburg, NY at approximately 1645 local time. The pilot elected to land in the corn field after…Accident 20120511006939AInfinity 2000 · Hurricane, UTOn may 11, 2012, at approximately 0830 MDT while cruising down a ravine in a powered parachute with light winds at about 5 knots, the pilot suddenly encountered a downdraft. He was unable to climb and turn sufficiently to avoid hitting an outcropping of…Incident 20120510010329ICessna 210L · Mansfield, OHPilot was attempting a landing at the Mansfield Ohio airport. While selecting the landing gear to the down position, the landing gear did not indicate a down and locked indication. Pilot performed a landing and subsequently collapsed the landing gear.Accident 20120510009689AAirbus A319-112 · Fort Lauderdale, FLOn may 10, 2012 at approximately 1223 eastern daylight time (EDT) (UTC-4), an Airbus A319-112, registration number N951FR, operated by frontier airlines as flight 384 encountered in-flight turbulence which resulted in a serious injury (broken leg) to a flight…Accident 20120510009239ABeech V35B · Las Vegas, NMOn may 10, 2012 at approximately 2117 MDT a Beechcraft V35B bonanza, N645EP registered to robert m. siegel, collided with the ground after departing Las Vegas Municipal Airport, Las Vegas, new Mexico, while on a personal flight. Night visual meterlogical…Incident 20120510007249IGrumman Acft ENG Cor-Schweizer G-164B · Albany, ORUpon landing the seal in the left brake master cylinder failed causing loss of braking on the left hand brake system. This in turn caused the aircraft to yaw to the right and exit the runway. The aircraft colided with a large blackberry bush and came to rest…Accident 20120510006769ACessna 172R · Immokalee, FLOn may 11, 2012 at approximately 0945 local time, FSDO-19 received notification of an accident at Immokalee airport that had occurred at approximately 0920 local time. The morning of the accident, flight instructor [privacy data omitted] and student pilot…Accident 20120509029269ADonald K Stovall Pietenpol Aircamper · Rose Hill, KSPilot reported that shortly after take off the engine began losing RPM. He then attempted to return to Cook Airfield(K50). The aircraft was unable to make it back to the airport, striking trees just southwest of the runway. Both wings received substantial…Incident 20120509009929IPiper Aerostar 600 · Steubenville, OHDuring take off power application, aircraft developed a severe shake / shimmy. Pilot retarded throttle and turned to exit runway. During transition from runway to taxiway, the NLG assy collapsed causing the left and right propellers to make ground contact.Accident 20120509009889ACessna 172S · Jonesboro, AROn may 9, 2012, at 0800 CDT it was discovered, a Cessna 172, N118SV, registered to N118SV LLC, made a hard landing at Jonesboro airport, Jonesboro, Arkansas, while on a training flight. It is unknown if a flight plan was filed. The identity of the pilot and…Accident 20120509009429AGutierrez Pablino Hummel Bird · Defuniak Spring, FLWitnesses reported the aircraft was observed porpoising on takeoff around 30 to 40 feet above the runway and then climbed to approximately 300 to 400 feet. The aircraft then pitched nose high and stalled and started a nose down descent. The aircraft then…Accident 20120509008949AMooney M20J · Sterling, PAAircratf N9154K departed runway 23 and crashed shortly after take offAccident 20120509008829APiper PA-18-150 · Chelle Lake, AKUpon takeoff, pilot heard a thump. After landing at intended destination, pilot found rudder damage.Accident 20120509008729AChampion 7GCBC · Genoa, NEDuring landing phase of flight on runway 29 at Genoa Municipal Airport, the aircraft bounced three times. Pilot applied power to go around and lost control. Aircraft veered right and hit trees 300 feet from runway.Accident 20120509008699ABell 206B · Flora, INOn Wednesday may 9th at approximately 1305Z, a Bell 206B iii, N1069Z, crashed in a wheat field near Flora, Indiana. The helicopter was owned and operated by townsend aviation. The helicopter was being operated by brian townsend conducting agricultural…Accident 20120509008229ACostruzioni Aeronautiche Tecna P2006T · Cleburne, TXOn 05-09-2012 at 1920 (l), a Tecnam P2006T, N727TA owned/operated by skymates crashed during a go-around maneuver on a VFR flight with VMC weather conditions prevailing. The aircraft sustained substantial damage and the crew and passengers received minor…Accident 20120509007889ARobinson Helicopter R44 II · Grants, NMOn may 10, 2012 at 9:00 am N7523S, a Robinson R44 helicopter departed albuquerque sunport int. Airport for page municipal airport, page AZ., about .6 hours in to the flight the commercial rated flight instructor entered into a practice autorotation. When the…Accident 20120509007829ACessna T210K · Midland, TXDuring approach into Midland international airport (maf) the right main landing gear did not completely extend and lock in the down position. This was verified visually by the pilot looking out of the window. The pilot stated the green landing gear safe light…Accident 20120509007439AFlight Design Ctls · Moorhead, MNThe pilot was flying from kffm to kfar with an intermediate stop at kjkj (Moorhead). When leaving kffm, winds were light. Upon entering kfars trsa, the pilot contacted approach. He was given a squak code and was informed that the winds at kfar were calm. The…Incident 20120509006909ICirrus Design SR22 · Tea, SDOn 05/09/2012 @ 9:45 am, a Cirrus SR22 owned by serious business, LLC. Was involved in an incident during landing rollout. VFR conditions prevailed. An IFR flight plan was filed. The aircraft received minor damage. The pilot and passengers were not injured.…Incident 20120509006889ICessna 180K · Waterford, MIWhen landing on runway 27R the aircraft lost tailwheel steering and exited the right side of th erunway and hit a taxiway guide sign.Incident 20120508009459IPiper PA-32R-301 · King Salmon, AK5/8/12 PIC took off out of King Salmon, shortly after take off PIC smelled exhaust and smoke started to fill cockpit. PIC turned back and landed without further incident. Maintenance found oil leaking from hose on exhaust shroud. Maintenance fixed leak and…Accident 20120508009131ABeech A36 · Paducah, KYThe pilot attempted to start his aircraft engine, but found that the starter would not engage. Having had similar issues in the past, the pilot exited the aircraft and attempted to free the starter solenoid by tapping on it. After a second attempt to start…Accident 20120508008799ACessna A188 · Rockfalls, ILFirst flight of the day. Pilot checked wx night before accident. Pilot stated he over flew airport from his base located to the south, and noticed wind from north. Pilot elected to land to the east because he thought the wind was within the capabilities of…Incident 20120508008719ICessna T210N · Lansing, ILWhile conducting touch and go landings on runway 27 at Lansing muni. (Igq), the pilot extended his downwind to accommodate a Cessna 310 that was about 4 miles east landing straight in (about mid-field, before extending gear). After the 310 passed on final,…Incident 20120508008459ICessna 180 · Truckee, CADuring tail-up taxi practice, a wind gust caused the aircraft to nose over damaging the aircraft engine, propeller, firewall and right wing.Accident 20120508008039ACessna 177 · Hanksville, UTOn may 8, 2012, the pilot claimed to arrive at the spanish fork airport for a flight in a Cessna 177, N28WF, with his nephew. He claimed to have conducted a preflight and added 30 gallons of fuel to top off the tanks (48 gallons usable) from a transfer tank…Accident 20120508007639ACessna 207A · Grangeville, IDThe pilot lost control of the Cessna 207 aircraft upon landing at the grangeviille, Idaho airport (gic). This particular flight was conducted under FAR part 135 carrying freight for ups. Weather and aircraft airworthiness were not a factor in this accident.…Incident 20120508006759ICessna 172 · Idaho Falls, IDOn may 8, 2012, when entering the pattern at Idaho Falls Regional Airport, the pilot noticed the engine started losing power. After attempting to increase the power, he heard a loud bang, followed by a lot of smoke. The pilot observed the oil pressure was…Incident 20120507011549IPiper PA-32-300 · Tinian, CMPIC placed fuel selector on an outboard tank that contained minimum fuel. During takeoff engine lost power that required a landing on the remaining runway. PIC indicated to management he did not visually check amount of fuel in tank prior to departure.Incident 20120507010349ISikorsky S-52-3 · Midland, MIAn anonymous call was received by the grand rapids FSDO 05/16/12 regarding a helicopter that was reportedly hard landed, with minor damage. 05/17/12 surveillance was conducted and pilot was interviewed. The pilot reported during a hovering maneuver the…Accident 20120507009439ACessna 172R · Culebra, PRDuring an interview with [privacy data omitted] and having FAA inspector echegoyen as witness, he admitted that he didn't used the checklist and failed to D0 the preflight to the aircraft. He demonstrated a sincere, cooperative, and positive attitude during…Incident 20120507009359ICessna 172P · Topeka, KSThe pilot was on a local VFR pleasure flight. While returning to the Topeka billard airport, the pilot stated the engine lost power. He prepared to perform an emergency landing on the westbound lanes of highway 24. During the descent, he struck powerlines…Incident 20120507008119IEmbraer EMB-135KL · Laredo, TXOver sat at FL360 climbing to FL370 to avoid level 5 thunder storms light to moderate chop. We were in icing conditions at FL370, no eicas message for ice conditions. Anti ice failed to turn on so anti ice system was turned on manualy. Capt airspeed went down…Accident 20120507007879AAir Tractor AT-502B · El Campo, TXDuring agricultural operations for the dispersement of fertilizer, the pilot failed to maintain control of the aircraft. While operating out of a packed dirt and grass, farm runway, the pilot encountered stationary farm equipment in his field of vision. This…Accident 20120507007819ACessna 172P · Spokane, WAAircraft contacted the runway nose first and bounced back up and tried to keep flying. Stalled, and fell back to the runway sustaining damage to the nose landing gear and firewall.Incident 20120507006949IBeech 58 · Fort Lauderdale, FLFSDO 19 was notified at 0744 on 05/07/2012, two inspectors were dispatched to conduct an initial investigation. The asi's arrived at kfxe at 0930 hrs and where escorted to taxiway e (echo) by airport security. At the site it was noted that the aircraft taxied…Incident 20120506012569IMooney M20J · Clarksville, AROn may 6, 2012 at 1900 CST, a Mooney M20J, N9119Z, s/n 24-3341, was being operated by [privacy data omitted], a certificated private pilot, with one passenger on board. The pilot and his passenger were on a crosscountry flight originating at approximently…Incident 20120506008819IEvektor-Aerotechnik Sportstar · Delaware, OHUpon landing on runway 10 at dlz the left hand wheel assembly departed the aircraft. The aircraft skidded to a stop and the flight instructor and student exited the aircraft unharmed.