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 20120226003799IEmbraer-Empresa Brasileira De EMB-500 · Jacksonville, FLThe airplane landed on a wet runway and was unable to stop on the available length and went off the end of the runway. There was no damage to the airplane and the occupants were not injured. The pilot reported that there may have been an issue with the…Accident 20120226002929AStrout Frank Aventura II · Laceys Springs, ALThe aircraft had taken off around 1330 CST from a private runway on the mishap pilot's property after filling the fuel tank with 18 gallons of 93 octane automotive fuel (full capacity). The aircraft traveled about 1/2 mile at an altitude of 300 feet, when…Accident 20120225005529APiper PA-36-300 · Americus, GAOn departure from runway 28 at kacj, aircraft departed controlled flight; the aircraft began an un-commanded roll to the right. The pilot added full power, opposite aileron and rudder to maintain directional control. The aircraft made a left base for the…Accident 20120225004869AEurocopter AS 350 B3 · El Cajon, CAOn February 25, 2012 pilot [privacy data omitted] had a hard landing while piloting helicopter N118MB while working for mountain air helicopters on the san diego gas and electric sunrise powerlink project. [privacy data omitted] Stated that while on approach…Incident 20120225003319IAviat A-1B · Sierra Vista, AZPilot of N473AM was approaching to land on runway 21 at kfhu. The pilot stated that he encountered a left crosswind as he was getting ready to roundout and made the crosswind correction with left elevator and right rudder. The pilot then stated that the wind…Accident 20120225003259ABeech S35 · Dixie Valley, NVSubsequent to departure from runway 16, the pilot stated he encountered wind shear. The aircraft impacted with the ground about 1/2 mile from the departure end of runway 16.Incident 20120225003189IEmbraer EMB-145XR · Chicago, ILFlight attendant became nauseous and called the captain to inform him that she was not well. The captain sent a deadheading pilot to check on the flight attendant who was now unconscious. The flight attendant revived and was able to sit on her jumpseat for…Accident 20120225002529APiper PA-22-135 · Hebron, NEPilot hand propped the airplane. Upon starting, it turned right and ran into the the small terminal building.Incident 20120225002479IHermansen H Erik Vans RV-6A · Le Grand, CAWhile in cruise from sierra skypark (fresno, CA) to columbia, CA on Saturday, feb. 26,2012, 0900 the pilot heard a loud knocking sound coming from the engine. (O-360 A1A s/n L-38193-36A) the pilot prepared for an emergency landing by turning back towards…Incident 20120225002269IBoeing 757-200 Series · Grand Forks, NDDuring cruise flight at FL 360 got eicas " l hyd qty " message left system quantity read .48, and "rsvr" light illuminated on. Hydraulic overhead panel. Left system quantity was decreaseing .01 every few seconds, lowered gear with quantity reading about .25.…Accident 20120224012659AAirbus Industrie A321-211 · Philadelphia, PAOn February 24, 2012, at approximately 1700Z, us airways flight 1556, N162UW, an Airbus A-321, encountered severe turblence on arrival into the Philadelphia area. During the turbulence encounter, a passenger was exiting the mid-lavatory and sustained a…Incident 20120224005059IInterplane Skyboy · Mohave Valley, AZPilot departed from the eagle airpark in Mohave Valley, Arizona, for a two hour VFR flight. He was the sole occupant of the aircraft. Approximately 1.5 hours later the aircraft appeared to have ran out of fuel approximately two miles south of the eagle…Accident 20120224003619APiper PA-28-161 · Rapid City, SDOn 2/24/2012, at approximately 1330 local, the flight instructor pilot and his instrument student were on an IFR flight plan from rap to their home base (hon). They were assigned 9000'MSL. The pilot reported they were in IMC conditions. He reported the…Incident 20120224003029IPiper PA-34-200 · Denton, TXThis office has concluded an investigation of an incident that occurred during a training flight at the Denton municipal airport (kdto) on February 24, 2012. The instructor and student pilot failed to follow the landing checklist, which resulted in the gear…Incident 20120224002129ICessna T206H · Hollywood, FLN89PA piloted by [privacy data omitted] was landing on runway 18L at the Hollywood North Perry Airport (hwo) on February 24, 2012 at approximately 1704 LCL. After touchdown the aircraft departed the right side of the runway striking a small construction…Accident 20120223005039ABoeing 737-7H4 · Pawnee City, NEReview of FDR data,flight plan and pilot statement indicates that aircraft incountered wake turbulence from another aircraft.Incident 20120223004039IBeech 58 · Bessemer, ALOn February 23, 2012, at approximately 1300 local time, N6617N, a BE-58, departed the right side of the runway at keky (Bessemer Airport) after landing rollout. The pilot, [privacy data omitted], pilot certificate number [privacy data omitted], was the pilot…Accident 20120223003659ABeech 58 · Cypress, TXPIC was inbound to west houston, Texas (kitw) from vicksburg, Mississippi (kvks) on 02/23/2012. The flight according to the GPS in the aircraft lasted 2.2 hours. PIC did not file a flight plan and flew all the way VFR until he reached the houston area where…Incident 20120223002469ICessna CE-560XL · Mesa, AZThe aircraft was at the Cessna service center having a dual engine change and cable inspection. On their first flight with the aircraft they noticed a whistling noise in the cockpit and decided to return to kiwa. On final when they lowered the landing gear…Accident 20120223001859ACessna 172S · Key West, FLCessna 172S, s/n: 172S9408, N53589 arrived in Key West, Florida at approximately 1700(l) cleared customs and went to island city flying service (FBO). At 1748(l) the aircraft took 12 gallons of fuel, 6 gallons per side. The two pilots onboard departed the…Accident 20120222005279ATexas Helicopter OH-13E/M74 · Farmington, CAA ag air agricultural operator, certificate designator(mbdg) pilot [privacy data omitted] was flying solo spraying a field of wheat and while performing a turn had passed out or lost consciousness. Evidence shows that the helicopter main rotor struck field…Accident 20120222004959AAeronca 7BCM · Woodlad, CAPilot lost control of aircraft after landingIncident 20120222004049IEmbraer EMB-145LR · Rochester, NYOn February 22, 2011 at 23:47 EST a Embraer 145LR, N845HK, registered to trans states airlines LLC attempted to land at Greater Rochester International Airport on runway 22 and was involved in an incident when the aircraft slid of the end of the runway, in…Incident 20120222002249IBeech 58 · Teterboro, NJ[privacy data omitted] Stated that he was on a stabilized approach at night, during VMC, was cleared to land on runway 06 at teb and believed he put the gear down with one notch flaps. He went on to say that during the landing flare he heard a sound like a…Incident 20120222001839IBoeing 747-481 · Houston, TXAircraft fire protection system loop "b" failed during climbout. System loop "a" had been defered per the MEL, so the flt crew declared an emergency, followed the procedures, and returned to iah for an uneventful landing. According to the aircraft flt log the…Incident 20120222001719IPiper PA-28R-201 · Phoenix, AZAircraft took off from Phoenix dvt runway 07. Pilot reported bad landing gear indication prior to landing at dvt rnw 07. No damage to aircraft.Accident 20120221006279ALindstrand Balloons 180A · Temecula, CAPilot was on approach to landing when he contacted high voltage power lines. Power lines suspended balloon until they snaped. Balloon landing was hard.Accident 20120221003649ACessna 180H · Conroe, TXPilot in command (PIC) was giving instruction to his friend on take offs and landings in a tail wheel aircraft. When on the second landing the aircraft veered sharply off the centerline. PIC then took control of the aircraft but was unable to keep the…Incident 20120221002769IDehavilland Beaver DHC-2 · Kodiak, AKThe pilot stated that the purpose of the flight was to break in a new engine. The pilot wanted to do a full power take off with the engine completely warmed up so he headed for long island. The pilot circled the area and noted the reef in the middle and the…Accident 20120221002439AHaycraft Oliver Sport Hornet · Mariposa, CAWhile on a part 91 flight, pilot reported that he smelled smoke in the cockpit and within 15 seconds, smoke had entered the cockpit. Pilot performed an off-field landing. Upon landing, pilot secured that engine and along with the passenger, exited the…Accident 20120220003339ABurkhart Grob G-103A Twin II Acro · Mokule'Ia, HIThe student pilot approached to land with excessive airspeed and made an attempt to force the aircraft to land before the speed was appropriately reduced. As a result, the aircrafts contact with the ground caused it to bounce back into the air. The student…Accident 20120220002819ACessna 182A · Anchorage, AKPilot departed soldotna airport en route to Lake Hood strip with two passengers. En route, the pilot checked ATIS information and updated the weather for his arrival. Approximately 20NM from Anchorage, the pilot was in contact with Anchorage approach.…Incident 20120220002789ICessna 172N · Washington, IAUpon landing on the runway, the aircraft departed runway for unknown reason and struck a runway light. Pilot reported minor cosmetic damage to aircraft.Incident 20120220002749IBritten-Norman BN2A-26 Islander · Kodiak, AKAn islander, BN2, a reciprocating aircraft departed Kodiak Airport at 0947 local time on a charter. 20 minutes into the flight the left engine lost power, pilot also noticed a loss of oil pressure, pilot initiated emergency action, voluntarily shut down and…Incident 20120220002449ICessna 340A · Bishop, CAEnroute ucc to vgt. After climbing to altitude, pilot noticed a fluctuation in manifold pressure on the #1 engine (left) followed shortly by a loss in power. Pilot shut down the engine, feathered the propeller, declared an emergency and landed at Bishop, CA…Incident 20120220002279ICessna R182 · Carbondale, ILThe pilot reported that one main landing gear would not extend. The aircraft landed on a grass strip after an emergency was declared.Incident 20120220002209IBeech M35 · Indianapolis, INOn 02/20/2012, after landing at Indianapolis mount Comfort airport (mqj) from a pleasure flight from muncie, IN (mie), the Beech M-35 aircraft registration number N9743R nose wheel slipped into dirt, when the pilot missed the left brake pedal and the nose…Incident 20120220002199IEurocopter AS365N3 · Belair, MDThird party reports indicate that the aircraft had flames coming from the right engine during landing at a ground vehicle accident site. The fire was extinquished by fire fighters at the scene. Numerous attempts at obtaining pilot reports from the Maryland…Incident 20120220001869IPiper PA-32-301 · West Palm Beach, FLOn February 20, 2012, at approximately 15:40 hours aircraft Piper saratoga PA-32-301, N8225P, s/n 32-8006066 landed on runway 14 at Palm Beach International Airport (pbi). The aircraft was on a 14 CFR 91 flight from marsh harbour (myam) to pbi. [privacy data…Accident 20120220001849APiper PA-24-250 · Albany, TXOn February 20, 2012, at approximately 1920 CST, Piper comanche N7147P departed from abilene regional airport(abi) on a VFR flight to norman Oklahoma (oun), with the pilot and one passenger onboard. At approximately 1936, at an altitude of 9500-10000 feet…Accident 20120220001709AEnstrom F-28C · Kalispell, MTOn February 20, 2012, about 1030 MST, an Enstrom F-28C helicopter, N51727, was substantially damaged following a loss of power and impact with terrain at the Kalispell City Airport (S27), Kalispell, MT. The instructor and student pilot were not injured. The…Accident 20120219004941ABeech 35-A33 · Rio Vista, CAOn February 19, 2012, at 1844PST, a Robinson R22 helicopter, N7508Y, and a Beechcraft BE33, N433JC, collided approximately 8 miles south of Rio Vista, California. The R22 was enroute from hayward airport (hwd) to sacramento executive airport (sac) and was…Accident 20120219004931ARobinson Helicopter R22 Beta · Rio Vista, CAOn February 19, 2012, at 1844PST, a Robinson R22 helicopter, N7508Y, and a Beechcraft BE33, N433JC, collided approximately 8 miles south of Rio Vista, California. The R22 was enroute from hayward airport (hwd) to sacramento executive airport (sac) and was…Accident 20120219003449AAviat A-1C-200 · Bowling Green, OHAircraft touched down on runway 10 at the Bowling Green Airport. The aircraft made an abrupt left turn. Pilot corrected to the right. Ground loop ensued. Left main landing gear collapsed.Incident 20120219002509IPiper J4A · San Diego, CAWhile landing, student pilot applied excessive brakes causing the aircraft to end up on its nose. Acft sustained minor damage, specifically, acft prop destroyed. Minor damage to lower nose cowl.Accident 20120219002329ACessna 172M · Mayaguez, PROn February 19, 2012, at approximately 14:35, [privacy data omitted] private pilot certificate no.[privacy data omitted], Was landing at Mayaguez airport (maz), runway 9, in a Cessna 172 aircraft, N5286H. When the aircraft was close to touch down, the pilot…Accident 20120219002079ACessna 414A · Hayden, COOn 02/19/2012 @ 1535 MST, Hayden, CO, Cessna 414A, N4772A, impacted terrrain approx. 250 yards south of rwy 10. 6 POB (2 fatal/4 serious), aircraft destroyed, IMC conditions prevailed.Accident 20120219001829ACrain Jac A BD-4 · Clarinda, IAOn February 19, 2012, at approximately 1320 CST, a BD-4 (experimental amateur-built) crashed about 1.5 miles southwest of the Clarinda Iowa airport (icl). According to a witness, the aircraft was heading southwest and made a 180 degree turn toward the airport…Incident 20120219001529ICirrus Design SR22 · Midland, TXAircraft departed lbb enroute to mdd. The pilot stated he did not have the approach set up properly and carrying a little too much speed. The aircraft touched down long and exited the end of runway 16. The nose landing gear dropped into a ditch just past the…Accident 20120218006599ACessna 172S · Fairfield, NJ[privacy data omitted] Is a student pilot who was conducting a long cross country solo flight from Essex County Airport (cdw) to sullivan county airport (msv) to reading regional airport (rdg) and returning to Essex County Airport (cdw). On the final leg…