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 20120909026609ICessna A185F · San Simeon, CAOn 09/09/2012 at approximately 15:45 PST, N80SS, a Cessna 185 float plane lost engine power and made an emergency landing in the water approximately 16 sm north west of San Simeon, CA. The aircraft became stuck in a kelp bed while experiencing 6 to 8 feet…Incident 20120909026309ICessna 140 · Camarillo, CAAfter touchdown on runway 26, the aircraft nosed over causing damage to the prop, engine and engine cowling.Accident 20120909025699ABeech 35 · Geary, OKPilot and student under instruction were practicing emergency landing procedures and after missed approach to runway were attempting a go-arround. Engine started to run rough and student turned for an actual emergency landing while attempting to get fuel to…Accident 20120909023849ACessna 172H · Phillipsburg, OHPilot pulled power to idle and lost control of the aircraft. (Stall)aircraft dropped about 3 to 5 feet to the runway resulting in a hard landing and bounce. The force of the touch-down blew the noise tire damaged the nose gear, firewall and other areas of the…Incident 20120909023059IBombardier CL-600-2B19 · Lansing, MIPinnacle flight 3635 took off from Lansing Capital airport (lan) enroute to detroit wayne county airport (dtw) on September 09, 2012 at approximately 1830Z. At approximately 4000 ft the crew received a master caution warning for the oil pressure on the rt…Incident 20120909022979ICameron Balloons US A-105 · Bird In Hand, PAWhile attempting to land in the the yard of a private home balloon hit several power wires. Removing one of the wires causing power outage in the area.Accident 20120909021669ABell Helicopter Textron 206L-1 · Grand Canyon, AZ9/10/2012:Two asi's were dispatched to gcn to investigate an aircraft accident regarding an operators aircraft that reported an engine flameout while attempting and autorotation post maintenance inspection (manufacturers program 100HR).9/10/2012:arrived at…Incident 20120909021069ICessna 182B · Haskell, OKExperience & training of jumper: 368 jumps & completed aff training program at skydive tulsa June 2010.club affiliation: skydive tulsa,OK. Skydive airtight skiatook,OK. And several others in Oklahoma and other states. Stated he has no primary club. Parachutes…Accident 20120909019859APiper PA-28RT-201 · Jefferson, TXOn September 9, 2012, approximately 1500 central daylight time, a Piper PA-28RT-201 single-engine airplane, N2878V, sustained substantial damage when it ditched into a lake following a partial loss of engine power near gilmer, Texas. The student pilot, who…Accident 20120909019309ABeech A36 · Kansasville, WIN3224G, BE-A36, s/n: E-2924 departed from chicago executive airport (pwk) to lakeland airport, minocqua (arv) on 9/9/2012. At 1648Z, 1148CDT N3224G was cleared by mke approach direct arv, at 1652Z, 1152CDT the data block of N3224G dissappeared from radar.…Accident 20120909018639APitcairn PA-4 · Rawlings, MDAircraft took off from Hi-Rock (private) airport. At approximately 200-300 ft. the power slowly decayed until the aircraft could not fly. The pilot selected a field next to his runway and completed most of the turn. The airspeed continued to fall until the…Incident 20120909018449IPiper PA-34-200T · Oxford, MSWhile taxing after landing the pilot noticed smoke coming from the right engine cowling. After shutdown the pilot noticed flames coming from the front engine cowling. Pilot and passangers evacuated with no injuires. Fire department extinguished fire.Incident 20120909018249IThomas A Siminski Zenith CH 750 · Allentown, PAUpon landing, aircraft stalled just prior to touchdown causing aircraft to land hard causing a jolt and bounce, at time of jolt pilot advanced throttle and pushed forward on control yoke causing nose over. Aircraft impacted runway, collapsing nose wheel…Accident 20120908024179AAviat A-1B · Durham, CAAircraft departing from man-made water-ski lake. Approximately 2000' available for takeoff. Density altitude estimated to be about 2000'. Aircraft struck 40' high electrical wires at edge of lake, crashed and burned.Accident 20120908022159APiper J3C-65 · Kingsland, TXShortly after takeoff aircraft was observed in a nose high attitude approximatly 200 feet above runway then spiraled at a high rate of speed impacting ground fatally injuring the pilot the sole occupant. Aircraft was destroyed. Investigation showed engine was…Accident 20120908020539AMoore Edward R MXS · Borrego Springs, CAN21MX homebuilt airplane crashed 1/4 mile north of L08 after loss of control. Pilot attempted to exit aircraft. Parachute did not open. Pilot was practicing aerobatics at the time of accident. Injuries were fatal.Accident 20120908020299ABeech V35B · Elko, NVPilot reported in an email statement received on 9-10-12 the following; pilot took off on rwy 5 (7200') with 3 passengers at 0928.after rotation and gear retraction, back seat passenger said fuel was flowing out of the left main fuel tank. Pilot observed…Accident 20120908020059AStinson 108-2 · Nikiski, AKOn a cross country flight from homer, AK to merrill field, anchorage, AK:about 2 miles south of moose point, the airman who was acting pilot in command of a Stinson 108-2, lost control of the aircraft while he attempted to land on the beach. During the…Accident 20120908019359AGreat Lakes 2T-1A-2 · Monroe, WAAfter engine failure force landed in soft field aircraft rolled onto back as it slowed.Accident 20120908018549ASchoepflin Dale E DA-4-550 · Viola, IDPilot was dropping streamers while flying at aproximately 800 feet AGL over a large crowd of people gathered for a political fund raising dinner. Witnesses reported that the pilot appeared to be flying too slow and lost control of the airplane during a steep…Incident 20120908017949IBeech B-45 · Amarillo, TXThe pilot of this airplane was performing at a local airshow in Amarillo, Texas. He lowered the gear for landing and the nose gear came down to a 45 degree angle. The pilot radioed the air boss informing him that he was going to fly to Amarillo international…Accident 20120907023629ASocata TBM 700 · Horseshoebay, TXDuring routine landing pilot noticed unusual sound as he was lowering the landing gear. Pilot checked for and confirmed three green landing gear lights then continued with the landing. When pilot flared for the landing he noticed the left wing was coming up.…Incident 20120907023049ICessna 182T · Columbus, OHThe pilot on N229LP, was on an instrument approach to kcmh runway 28R, at 2.5 DME the pilot requested a side step to runway 28L for easier access to parking. The pilot stated that he began his sidestep manuver at 1.5 DME, he also stated that he was stabilized…Accident 20120907021059AGoodyear F2G · Valley City, NDMr odegaard was practicing for the wings and wheels air show to be held on sept 8, 2012 at Barnes county airport, Valley City ND. He had completed several manuevers including an immelmann, half cuban eight and 4 point roll. He had made a wide turn and was…Accident 20120907020849APiper PA-18-150 · Mccarty Fjord, AKThe PIC went to Mccarty Fjord for a fishing trip. Upon reaching the Fjord he overflew the beach area which he has landed on many times before between 400 to 500 feet to visually check the beach before landing. After checking the beach and determining that it…Incident 20120907020799IGates Learjet 55 · Indianapolis, INThe part 135 flight emanated from the Indianapolis International Airport (kind) in route to the north bay airport (cyyb) located in ontario Canada. The pilot reported that within 5 minutes after takeoff, he noticed the circuit breaker for the…Accident 20120907020559AAyres S2R-R1340 · Brawley, CAAyres Corporation S2R-R1340 impacted terrain while departing an off airport dirt strip 6 miles northeast of Brawley CA at 0619000PDT. 1 POB sustained moderate injuries. Aircraft was substantially damaged.Incident 20120907020309ICessna 525 · Eagle, COOn 09/07/2012 at approximately 1200 hrs. MDT, N520RM, a Cessna model 525 citation jet aircraft sustained minor damage while landing at Eagle County Regional (kege) airport, CO. The five occupants on board were uninjured. Weather at the time was visual…Incident 20120907020119ICessna 414 · Pittsburgh, PAOn climb out from Allegheny County Airport passing 13,000 feet, the copilot's windshield cracked and pressurization was lost. Aircraft returned to agc and landed on runway 10 at 1751Z without further incident. Further inspection found no evidence of…Accident 20120907019879ACessna 182T · Mullins, SCOn September 7, 2012, at 0810 hours, N635CP, a Cessna 182T operating part 91 VFR, was performing short field landings on runway 22 at Marion County Airport, SC, (mao). The aircraft landed and the nose gear collapsed, causing a propeller strike to all three…Accident 20120907019749AKorrison Tom Sparrow Hawk · Spanish Fork, UTPilot was performing take-off roll of solo flight in this aircraft type and lost control of the aircraft causing it to veer off the left side of the runway. Damage to rotor system, flight control, and major structure.Incident 20120907018939IBeech A36TC · Bend, ORPilot in command failed to place the landing gear lever to the down position due to a distraction on the radio frequency. As a result, the A36TC aircraft landed with the gear not down and locked.Accident 20120907018629ARobinson Helicopter R22 Beta · Newman Lake, WADuring an instructional flight, student pilot was practicing hovering over a grass/dirt field when he began to lose control of the hover. With the helicopter drifting right and pitching forward it struck the ground with the skid, causing the helicopter to…Incident 20120907018599IMitsubishi MU-2B-40 · Lincoln, RIThis was an instructional flight, training the student in MU-2 iaw with sfar 108 from koqb to ksfz. Aircraft departed koqn runway 27 which is 3347FT long. At approximately 90 knots the aircraft made a significant lurch to the left. Instructor immediately took…Incident 20120907018339IBoeing 767-281 · Kent, WADuring acft approach to bfi over Kent, WA, RH MLG shock strut door assy fell off acft striking ground in residential neighborhood. No damage or injuries on ground.Accident 20120906029139AFairley Gooch Lancair IV · Winnsboro, LAThe accident pilot was flight testing his lnc-iv amatuer built aircraft in accordance with phase I. He departed Winnsboro airport (F89) at approximately 1109 and was heard and seen returning to F89 at approximately 1245 by witnesses that were outside a…Accident 20120906021549AHawker Beechcraft G36 · Decatur, TXAircraft canceled IFR and executed a visual approach to landing. After entering a left down wind the aircraft then turned to a close-in left base. Because the aircraft was high and fast on final it bounced two times after landing. The pilot then executed a…Incident 20120906021239IRaytheon 390 · Nashville, TNOn approch to jwn (john tune)the landing gear was selected down. Cockpit lights indicated the nose landing gear was not down and locked. The landing gear was cycled several times with the nose landing gear still not indicating down and locked. At that time…Accident 20120906020629APiper PA-25-235 · Jasper, MOPilot departed lamar, MO airport (llu) for aerial application work approximately 1 mile southeast of Jasper MO. During a turn to prepare for an application pass, the engine lost power and the pilot made a forced landing in the field.Incident 20120906020619IGrumman Aircraft ENG C-1A · Mcgrath, AKIn preparation for landing at the nixon fork mine runway, the pilot elected to abort the landing due to turbulence. The pilot selected the landing gear to the up poisition. After the gear retracted the pilot notice a gear unsafe indication, on the gear handle…Accident 20120906020499AHolloman L B/Holloman E M Sonex · Chapmansboro, TNDescription:mishap aircraft was departing home (private grass) airport(TN77) to the south. At or near rotation airspeed, aircraft developed slight rolling tendency to the left and began skipping main gear to the left of runway centerline. Winds were light.…Incident 20120906020489IBeech C90A · North Las Vegas, NVOn September 12, 2012, [privacy data omitted]/pilot) was holding in the runup area copying a departure clearance out of vgt (North Las Vegas). The aircraft crept forward and struck a taxi light. The propellor on the left engine sustained damage to the outer…Accident 20120906019659ABeech 76 · Manville, NJAircraft tried to land on runway 25. As it touched down it began to porpoise. Pilot decided to go-around and applied full power. The aircraft turned sharply to the right. As the pilot banked to the left to try to correct the situation, the left wing struck a…Incident 20120906019059IAble Joe R Challenger 1 · Paragould, AROn September 6, 2012, at 1830 CDT, a challenger 1, N4050T, experienced a hard landing at Kirk Field Airport, Paragould, Arkansas, while on a pleasure flight. Visual meteorological conditions prevailed at the time, and a VFR flight plan had not been filed. The…Accident 20120906018279AHansen Michael P HANSEN-VANS RV-6 · Lemolo Lake, ORStudent pilot on third leg of a long cross country solo training flight. He had departed the sun river airport for medford, Oregon on this leg and was at 10,500 feet (appropriate). Enroute his radio transmissions did not seem to be getting thru to center and…Incident 20120906018239ILockheed P2V-5F · Missoula, MTAircraft was on a maintenance test flight when the chip dectector light illuminated for the number 1 engine. The engine quit running. The crew feathered the propeller. The crew perfromed emergency procedures and declared an emergency and landed the aircraft…Incident 20120906017919IBombardier CL-600-2B19 · Denver, COAfter the aircraft had been pushed back from the gate and prior to taxiing, a fuel truck backed into the aircraft causing damage to the right winglet and navigation light. There were no injuries.Accident 20120905024829ACessna 421B · Fort Worth, TXOn September 5, 2012, at 0949 local central time, Cessna 421B aircraft ,N69924, crashed after takeoff from Fort Worth spinks airport, Fort Worth, TX. Prior to the crash the pilot informed the tower that a door had popped open and that he was returning to…Incident 20120905023859IBoeing / Dehavilland DHC-8-103 · Anchorage, AKEra 874, dash 8, departed ted stevens international airport, Anchorage, AK on a scheduled flight to homer, AK with 12 passengers and three crewmembers. The flight was the second mission on that day for the flight crew. Initial clearance altitude was 10,000'…Accident 20120905023669ACessna 175B · Hamilton, TXOn September 5, 2012, at 1555 central time, Cessna 175B aircraft, N8260T, experienced engine failure after takeoff from Hamilton municipal airport (kmnz), Hamilton, Texas, and crashed 100 yards from the up-wind portion of runway 18. The aircraft was piloted…